Search results

Is it possible to alternate the background color based on a text box (txtProductID) in each row in a continious form? For example, my forms detail section has a back color and an alternate back color which I still want BUT I want it based. on the text box (txtProductID). In the example image...

@MajP I noticed something in my database that I used the code from your example. If you click the button to add records then it "Looks like" your adding records BUT they are records from the previous record and not a set of new records. I found this out when I added numbers in the count control...

@Uncle Gizmo Your suggestion works Thanks! @MajP I used your shortening examples, Thanks!

@Edgar_ Your example works some what. I tried your example, and it checks every time and gives a message BUT when all the controls have data it runs the code BUT it runs it 3 times? How do I get it to only run one time? Dim arr(1 To 3) As Variant Private Sub cboEmployee_Change() arr(1)...

@The_Doc_Man I tried your example and it didnt do anything? Private Sub cboEmployee_LostFocus() CtDtFlag = nz(cboEmployee, "") <> "" End Sub Private Sub txtCountDate_LostFocus() CtDtFlag = nz(txtCountDate, "") <> "" End Sub Private Sub cboShift_LostFocus() CtDtFlag = nz(cboShift...

@Uncle Gizmo I tried and it didn't work like your video showed. I noticed in your video you typed text into the combo boxes and mine I select an option from the combo box. Maybe that's why mine don't work and your example did?

Thank you all for your suggestions/examples, I posted and got pounded with a lot of extra work so I'm going to put on hold for a few days, Ill post back what worked! Thanks All,

I have a main form with a sub form.... The main form has 3 controls (1 text box, 2 combo boxes) and when I enter data I need to run a Public function that if the controls are null then do nothing but if they have data then run SQL and update the subform. I used On Change, Before Update, After...

@June7 I read it earlier I forgot it didn't reference the combo box in your example SQL.... Sorry! Also, thanks for adding the accidental clicks that was my next question! Thanks so much for your help! @MajP Thanks again for your help!

@MajP, Yes its sort of what I'm after..... how could I get rid of the combo box all together and "auto batch" add a record for every product/length instead of selecting them from a combo box.

@June7 I removed the "Length" from [tbl_InventoryDetails] as MjaP instructed so that would change your batch insert to what because I'm only saving the count in there now. I probably would want a button to insert all the records for now...

Ok, I changed the [tbl_InventoryDetails] by removing the other fields specified that wasn't needed. I then unbounded the cboProductID and I changed the relationships to below. Now, im not sure how you guys are explaining how to have it auto enter all the lengths and product names into the...

Hello, I need help designing this database for collecting a number count for each products lengths on a single date like shown in the image example. I need to find a way that once I select a date, shift and employee from [frm_InventoryOverview] form then [sfrm_InventoryDetails] form will...

@plog thanks for the help, Ill keep poking at it....

@plog I'm sorry I'm not getting how to set up the form to retrieve the data and to add a count for each products length. I setup your structure in the new test DB.

Hello, I'm trying to figure out how I can create an inventory database count per date for all products/lengths. What I have so far in the attached test DB is if you open the form (frm_InventoryCountDay) you have to enter date inventoried, who did it and what shift was it on. Below that is a...

@arnelgp Thank you again!

@arnelgp Hay can you give me another hand with this? I been playing with the examples you have given and I am getting an error 1004 Range Class failed and I cant figure out why? The username get username works but I get the error when trying to run the get password I get the error and debug...

@theDBguy I can delete and add to the temp folder, for some reason when I tried to manually delete the file I got a message it was being used so I stopped Excel process and was able to manually delete. Even though I had Excel closed, there were a few Excel processes running... Anyways, its...

I thought kill file was deleting it, or is it close it?