I am developing an Excel project in Access using VBA. My project is working in Access 2007, but it does not work in Access 2003. If I try to run the file, it shows the DLL error. Anyone know how to debug this error? ...
I need to create a form in which user can select one item from the table. Then user can click on button so data in selected row can be used in next step. I am unable to find optimal solution. First, I don't know how to make such view/table with selectable items. Second, I don't know how to gather data from selected row. I am totally new...
Hi This never happened before, the apd doesnt return any error messsages, just calls the stored proc (delete statement) but doesn't complete, no error message. This only happens when calling the sp on SQL Server 2005, it's fine with the same query in SQL Server 2000. It doesnt make any sense! Please Help!! I've run out of ideas, I wi...
So the function =Now()....is there a way I can use this and only get the date, not the time? or is there just a function for this idea? thanks Justin ...
Yesterday when I was working on a module in Access 2003, when I closed it, Access crashed. I think what I had done was renamed the module. After reopening Access I saw the new renamed module, but got the ol' "The module name "..." is misspelled or refers to a module that doesn't exist" error. I am unable to open it in the Database Window...
It's a little complex. I'll try to be as clear as I can. It's a work plan. We make estimation of the total time needed for a task, say 100 hours, and break it into periods of month. For example, 30 hours should be done in March, 20 hours in April, and 50 hours in May. After every month, the plan can be changed. I need to keep both the...
i create a linked table and it works fine. but when i close access and open it again the table is gone. why is that happening ? i am using access 2003. ...
If I have a report that tracks data for several accounts for each month with rows labeled: UNITS, REVENUE, AVG REV/UNIT How would I create a query that will filter the report to just show accounts where the UNITS row has increase/decreased 25% and the AVG REV/UNIT has increased/decreased 10%, from the previous month to the current mont...
I'm writing a query that has to count the number of students enrolled in a course, and the way I'm doing it is like this: DCount("[student/course table].[Student ID]","[student/course table]","[StartDate] = #" & [Course Start Date] & "# AND Location = '" & tblCourseDetails.Location & "' AND [Course Number] = '" & [Course Number] & "'") ...
How can I create access 2000-2003 file using C# WPF and add tables in, data in and perform queries on it? I`m using MS Visual Studio 2010 this is what I`ve been able to accomplish: OleDbConnection conn = new OleDbConnection(); string myDir = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location); strin...
Hi, I am using MSAccess 2003 for my application. When I am trying to access PDF ActiveX control, an error message is displaying as follows The operation on the OLE object failed. The OLE server may not be registered. To register the OLE Server, reinstall it. I tried reinstalling MSOffice, but that did not work. Can anyone help me ...
Lets say I have two tables, one for transactions, and another table who's primary key is the foreign key in the first table, and this relationship simply associates locations to transactions. I have a form with a list box that shows all the potential locations, so that the user can open some dashboard forms that only pertain to a given ...
I've read opinions across the internet that say if you design or MS Access FrontEnd properly, it shouldn't shrink too much when you do a compact. I've got one front end I'm using that is typically around 15 MB when compacted, but grows to 20-25 MB while I'm working on it! Is this something I should be concerned about? ...
Hi, I am using this code to print a record from the form Private Sub btnPrintRecord_Click() On Error GoTo Err_btnPrintRecord_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.PrintOut acSelection Exit_btnPrintRecord_Click: Exit Sub Err_btnPrintRecord_Click: MsgBox Err.Description Resume Exit_...
I am attempting to open a document from access, execute a mail merge, and then save the document output from the merge using VBA. Here is my current attempt: Dim templateName as String, tempRoot as String tempRoot = "C:\report\" templateName = tempRoot & "template.doc" Dim objDoc As Word.Document Dim objWord As New Word.Application Se...
Some users will use the database as read-only and some will need to add, delete and update records. Now, users that will be read-only on the database also have the read-only rights as windows permissions on the backend directory. What happens obviously is that the backend becomes read-only. I thought using the access security thingy wo...
Hi folks, Apologies for posting this but although there are a few examples on the site, I just can't get mine to work. So I have two tables as follows: A Telephony table ID | Name | GradeID 1 Richard 1 2 Allan 1 3 Peter I also have a Grade table: ID | Name 1 1 2 2 3 3 4 4 5 5 Anyway I'm trying to us...
hi i try this in access 2007 and its work excellent !!! but in access 2003 it dosent work what can be the problem ? public string Office2003 = @"C:\Program Files\Microsoft Office\Office11\msaccess.exe"; public string Office2007 = @"C:\Program Files\Microsoft Office\Office12\msaccess.exe"; ProcessStartInfo MSAccessInfo = new ProcessSt...
I have a MS Access 2003 mdb acting as a front end for a SQL 2008 back end. The back end contains a table with a varbinary(MAX) filestream column. I can use the front end to upload files to the database using a stored procedure. I'd like to store images in the BE for display in the front end, but I can't figure out how to bind the files s...
I have a MS-Access 2007 client using a MS-Access 2003 MDB frontend and backend files. Disabling the ribbon bar shuts out some unwanted behavior (such as navigating records... even though I have 'Record Selector' set to false, it still persists in the Ribbon bar), but when I do this, then the printing options are lost when in the print p...