Search results

Thanks for responding Paul, Do you mean I need to add this to the existing code?

Hi, i found this code and have substituted parameters to suit my own needs however the loop is not working. Only the first record in my recordset (which is a test recordset of only 3 records) is being updated. also, for testing only, the edit or update being applied is trivial: Description =...

Hi Mihail , thanks for response, I need to use it as a subreport i suppose: I'm not formally trained in access, but what i have is a report that I print as a Packing list; the packing list source is taken from tblSalesOrders which draws the main order info, and then a linked subform or...

Hi, How do I pull information from a subform (more than 1 record in subform at times) to put on my report? I have added the subform to the report and set Visible property to No, I know the syntax to refer to the subform and its fields but I don't understand how to get all records in the...

Hello Access Users, I've got a form built on a tab control. The form is a sales order form with multiple tabs. One of the tabs is used to enter shipping information and cost. The problem I'm having is: A field I have added to this tab which is a stored total of the sales order total plus...

Thanks, i found the listcount property and I'm able to determine when my listbox has only 1 value in it, but how do I select that value before setting focus to the next listbox? Thanks for any advice, I'll keep looking in the meantime Brian thanks I found the answer: Me.cboDescription =...

Hello, I'm having a hard time improving the functionality of my inventory form, hopefully someone can help! My form utilizes five list boxes. The user must choose from each of the five list boxes in order to filter out a specific product from a products table. Every time the user makes a...

i'LL TRY THAT MARK, THANKS!

Hi, I need to exclude non-integers in my query and have forgotten how to do this. Can anyone help on what i need to put into the criteria field within my query to to this? Thanks for any suggestions

Hi David, tblTrackingInfo has two entries for that order because the order was shipped by two different carriers each with their own amount. tblTrackingInfo is used as a subform in my Sales order form allowing for as many entries as needed, although it is rarely, almost never more than one...

Here is the sql: SELECT tblSalesOrders.SO, tblSalesOrders.DateEntered, tblSalesOrders.ProductNum, tblSalesOrders.OrderDate, tblSalesOrders.ServiceID, tblSalesOrders.ScheduledShipDate, tblSalesOrders.RequestedShipDate, tblSalesOrdersDetails.ProductNum, tblSalesOrdersDetails.WidthInches...

Hello, The query I have made is to generate an Entered Sales Order Log for a specific time frame (user sets time frame, then runs query for a report) The query is comprised of 5 tables in order to pull the information that I want in the report. The problem I'm experiencing is that one of the...

Hello Gemma, yes I'm definitely acquainted with some of the glitchy aspects of tab control, i got code from a site that runs in the command box to convert all labels to text boxes on the form at once! I'm still running Access 2003. Do you have a later version? Does the tab control act the...

Thanks alot for the response Bob, I tried your workaround and it works fine. I will try to implement it in my database where needed. Brian

Will someone please take a look at the attached sample database from my last post and help! Thank, Brian

I tried your code Hkimpact, but it didnt make any difference. I am uploading a sample database that clearly represents the problem i am talking about. The combobox on the form has to be clicked twice on the arrow to dropdown because it has dropdown code on its got focus event. However, it...

Hi, I found this thread listed a while back in 2005, but there were no replies, so I am bringing it up again because it is very annoying and hopefully soemone here know the solution. "I sometimes use the standard Me.mycombo.Dropdown in the GotFocus event of a Combo Box. I've noticed that when...

To Brianwarnock, Thank you so much, the code works great and does exactly what i was looking for it to do and without clicking the buttons. Sincerely, Brian

Hi Alan - Please see attached file: There is a sample product in row 3 I'd like to have the same functionality by using the Received and Assembled buttons when inputing further products in rows 4,5,6 and so on. Right now if I put a number in the received column in row 4 or 5 or anyother...

How do i upload an file to a user that has responded to my thread?