Search results

I'm not sure if I can explain what i'm trying do but here goes! I have a form and a subform. On each detail line I need to repeat that line on a report a specified number of times. I created a field in the details table to hold that number. I did get fairly close in that I was able to repeat...

Hi all! I have been going over the different posts in here and trying many different things to get this to work...I have a frmOrders with a sfrmOrderDetails. If the product in the orders details form is not in the drop down list you can double click and it opens the products form to add the...

Hi all! Here is the problem: I have an order form with a subform for the order details...pretty standard...but now we've decided to start a lot number system. What I need to do is be able to place a lot number on each detail line for the product shipped but then realized that I will need to...

I looked at the last post on the dlookup function but i am unable to get it to work in my code. I get the same error about automation. txtFloat = DLookup("Float", "tblMash", "MashID =" & Forms!frmFishManual!LstMash) I've tried adding single and double quotes in different places but to no...

I am attempting to open an excel workbook from access but excel is continually crashing. I have no problems opening workbooks outside of access so i'm assuming its the code thats messing it up. Static wbWorkbook As Excel.Workbook Set wbWorkbook = GetObject("C:\My...

I think that the transfer spreadsheet is fairly straight forward but the only problem i'm having is that the spreadsheet is never the same. Its the same format (template) but different data all the time so I need to be able to call a find file dialog box or something along those lines that...

I am trying this code to run an append query but I keep getting the error: syntax error in INSERT INTO statement. This is the statement i'm trying DoCmd.RunSQL "INSERT INTO tblInventoryAdjustmentsArchive AdjustmentID, ProductID, MaterialsID, PackagingID, [Date], Comments, QtyOnHand, QtyCount...

I am using ADO code to update values in a table from one of my forms but more often than not i get a message that states: Could not update; currently locked by user 'Admin' on Machine "X". Some of the code updates great so does anyone know what causes the record to be locked? thx CAP101

I am trying to set the source object in VBA for a subform control on a form. I have tried this code but access says it cant find the form. Any help would be much appreciated! Dim objMaterials As Object objMaterials = [Forms]![sfrmPODetailsMaterials]...

I have a list box in my macro that does this if its Null: MsgBox("Do you want all sizes?",4,"Size")=7 I want the macro to ignore this if the listbox is NotNull but I can't figure out how to do that. Any help would be much appreciated!!