Search results

DOH! I was so focused on the "Ind" part that I just didn't notice the Db vs Dr. Works now. Thank you for the extra set of eyes.

That was the first thing I checked for. The spelling is correct on both sides (a capital "eye" not a lower case "ell"). And I tried changing the field name in both tables to just "DrCr" and "DrCrNew" to no avail. Another point to add is when I step through the code and hover over each of the...

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...

Thank you both plog and arnegp for your solutions. I ended up using the reference provided by plog to set up my filters. I was still having an issue when filtering with multiple combo boxes but found an elegant solution on another forum, one the author had posted out there to share with others...

Thank you all for your responses. First, for the combo box that filters on Format, I had set up the event procedure but forgot to put the criteria statement in the forms underlying query. Doh! This is now fixed and functioning properly. The Artist filter is still an issue. This field and all...

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...

I have also tried saving an .mdb file as .accdb but the new database would inherit whatever setting was not allowing me to delete objects. So in the end I have moved everything to .accdb files by importing the objects into new blank databases. I thought there might be conversion problems but it...

Been there done that. It doesn't act any differently from one drive to another. Plus all of the drives have been designated as trusted sites. Thanks, John

I have not tried to create a new DB although, I discovered this issue through the process of copying tables into another DB and then trying to delete the table that was already there. Also, I can create and modify objects in all of the DBs. Now I made a new discovery last Friday and that is I...

Thanks for the responses. The navigation pane is not locked and migrating to the 2010 format is just not in the cards at this time (besides dealing with the other users, there is a definite lack of time and resources). When I was upgraded to Windows 7 from XP I assumed Office 2007 would remain...

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...

These are unbound fields but the good news is that CInt() worked. Thanks again for the help. John

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 figured out the problem - operator error. I had changed the field name for ProdCenter in my test copy but forgot to move the associated table to the split database. Live and learn! And thank you for the reply.

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...

Thanks Jacob, but I'm already there. tblMPSDATA is an existing data, and the first step in the import routine is to empty the table with the delete sql as you showed. The material field is already set to text.

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...

Form is Now Unlocked Here is an update. Just after replying to this thread it occurred to me that I should also try replacing the main form from the backup database. I did and now I am back in business. The replacement main and subforms are working correctly again.

My Form is Locked Also This same problem occurred in my database just last Thursday (2/10/05). I have a form for manufactured products and a subform for direct labor hour time details assigned to each product. I cannot add a new record nor make changes to any existing records in the subform...

Thank you Adrianna for your response. You are correct in that it is a hierarchy. Some additional background: I am using three tables; one for assemblies which goes one level deep (the immediate parts necessary for any given assembly), one for components (every part available for use, both...