Recent content by CAP101

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