Search results

I am populating a table using vba and the routine fails on the field "DrCrInd" with the error 3265. If I comment out this field under the .AddNew the routine works fine. The field name spelling has been checked and it is correct. I even renamed the field in both tables and still the same error...

I have a continuous form connected to tblMedia, containing right now vinyl LPs, DVDs, and Blue-Rays. When the form was created there were 280 records for vinyl LPs and the form could be filtered using a combo box for Artist. The combo box can also display blank and all records will show. I have...

Two weeks ago I had Office 2010 and Windows 7 installed on my work computer. Before that I had Office 2007 and XP. Before the move to 2010 I could delete objects in the navigation pane, now I cannot. * I am working in MS 2003 databases. * These are not secured databases. * I have checked the...

I have a database where a user selects on a form, a year and a range of periods (months in the year) on which to run a report. The periods are between 1 and 12. Validation code checks to make sure the From value is less than the To value. Example: to see data from July through October the user...

I have a time reporting database called Productivity. I also have a split version with ProductivityFE containing the forms, queries, and reports and ProductivityTables containing the data. All three are on my PC. Each month I update Productivity with new records and run a report or two to check...

I am importing an Excel file of production data into a table using the TransferSpreadsheet method. Here is a snippet of the code: DoCmd.TransferSpreadsheet acImport, , "tblMPSDATA", _ "" & stFilePath & "", True, "" Everything works fine except the column which contains 'Material' holds...

I am trying to create a bill of material for labor time standards. Using a piece of code I found on the web (BOM.zip) I have been successful in assigning the proper level number to each component in the BOM, however the sequence is not correct. What I get currently is: 0 Car 1 Engine 1 Wheel...