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

Excellent! Thx again Pat

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

Excellent option and worked perfectly! Thank you very much for the suggestion

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

At the beginning of your module try using the line: Application.SetOption "confirm action queries", 0 and then the line: Application.SetOption "confirm action queries", 1 at the end of the module. I'm not positive whether that will still work if there is an error but it will turn off the...

Please excuse me, i've figured it out. To think, it only took me three days to get the criteria expression correct! varFloat = DLookup("[Float]", "tblMash", "[MashID] = '" _ & Forms!frmFishManual!LstMash & "'")

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

Thanks for your reply GaryC. What corrected the problem is adding the line: wbWorkbook.activate After that worked, i created a macro in excel and saved Personal.xls and then rehid it. Now i've had to change my code in access to: wbWorkbook.Parent.Windows(2).Visible = True The original...

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

The open/save dialog works perfectly. Thanks for your help!

Thx for your help. The Browse folder dialog works like a charm in my code but I need to be able to select the file, not just the folder. If I can get that i'll be laughing...

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

Thx very much. The parentheses were the missing ingredient.

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

Thx a lot!

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

This macro is being called from a form and I am using the conditions column to test for a null value. If the combobox on my form is null, I want the msgbox to run but if there is a value in the combobox on the form, I want the macro to ignore the line: MsgBox("Do you want all...

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