Hi,
I just installed MS Access 2007 and our company has a custom designed database that I would like to migrate into 2007. The first issue I had was the Date Function not being able to be fou...
I am wanting to send one of the tables in my access database as an argument to a Public Function I have created that needs to open the table as a recordset. I want to be able to send differen...
I have a form called frmSelect Date with a field called txtbegDate that I am entering in a date. An OK and Cancel button is included so if OK is selected it fires off an update query to ad...
Hello Experts,
Our company has used Excel for scheduling purposes. I am now in the process of migrating the Schedule board from excel to Access and need advice on the best way to recreate a ...
I have a macro that hides a number of controls after clicking a control called cmdLogout. However, I want cmdLogout to also hide as the macro executes. But this brings up an error because it c...
Hi there
I need to display data in a datasheet from stored procedure in SQL 2005. I also want to use parameters that come from fields in Access to send to the stored procedure to filter the d...
I am not sure this can even be done, but here it goes. What I would like to do is create a button that has a parameter in a query that will ask me about a health system, when I put in that he...
Probably going about this the wrong way....
But ...
From a command button on a form, I'm exporting data from a table to an xml file.
The problem is, on the second line it puts the following...
I am writing a routine in MS Access which needs to repeatedly find records in a SQL Server table.
I cannot use .Find because I need to search on 2 fields. I would like to use .Seek, but as...
I am trying to return the result of a function into the where clause of a query. I get no error messages but my query returns no results. When I hard code the expected result of my function,...
Hello Guys,
I have attached a picture of the table I'm working on so it's easier to help out. I have the following code.
AccName = DLookup("[Account name]", "Requests Table", "[Job Statu...
I am using this code to autopopulate fields in the form. the fields get the information from a seperate table to the main table. but when using this code in the after update i get an error mes...
Greetings:
Weird problem - I must be missing something. I have a form in which I do a series of queries persisted to tables, and the final one I query and put in a recordset to populate the c...
Hi
Need to add appointments to a calendar in Outlook from Access. Found the code below from Microsoft Support which works fine using the default calendar, but I need to add the appointment t...
Here is an example of what I want to do.
Column A Column B
firstname Joe
lastname Bob
companyname cworks
notes ...
The function returns a value when debugged, but the query in which the function is called returns nothing in the field - what can be causing this issue -
i need to determine if a field sta...
I did to create a lookup field that contains a list of all objects in a database along with type of object it is:
I thought to use the Sysobject table - need a query that will give this lis...
I am using MS ACCESS module trying to connect to an Orcale DB- 9i - here it the code ,"I got Multiple - step error " when trying to fetching the date field form the recordset, I saw some peop...
I need to filter a query. This comes from a previous question I had. I was trying to move information from one database table to another. That is taken care of but I'm having issues with it...
I am developing an Acess app.
I set breakpoints in the VB and nothing happens! I have decompiled the app but that makes no difference. Also I compacted and repaired and that had no effect....
I have two different forms looking at two different tables. Both forms look at related fields. Both fields in the two tables are named "ProductNumber" Both tables also have "ProductPosition...
Okay I have a form, ParcelInformation that has a subform called ParcelLocationInfo.
The main form, ParcelInformation shows the following fields:
ParcelNum, LastUpdate, Situs Address, ParcelN...
Hi,
I got a code which throws error when i try to import to table students from excel...
I have attached the database file...& code....
I am trying to make a cmdPrint option open up the Print Menu to allow the user to select which printer to print to. Any suggestions. See Code Below.
I have Office 2003 installed on my machine with a number of apps written in Access. The apps interact with Excel, Word and PowerPoint.
I have to begin upgrading to Access 2007, but still m...
