Recent content by lscheer

CJ_London, Your assumptions are correct!

Apologies! I am interested in utilizing the VOU transaction record only, but pulling the Descr string from the PO or the REQ record (either is fine) that matches the first 30 characters of the Descr string in the VOU record. However, since multiple (but not related) records might match the...

Thanks to some complete MORON who obviously doesn't know the basic concepts of database development and implementation, I am in the unfortunate position of having to work around their stupid constructs to try to get useful data into our own internal database. And now for my convoluted...

Perfect, thanks! I can't believe I spaced DMax. And yes, since DMin and DMax work for both the start and end dates, I will just use those.

I have an invoice report that has a calculated control for billing cycle. Currently it is set to =[Enter start date] & "-" & [Enter end date] This is because the start date depends on the date of the first charge and changes every month, so the user enters the dates simply for display...

boblarson, Thanks for your suggestion, however it didn't seem to help. The blank record is still added to the Contacts form. I did try playing with something else and that was setting the DoCmd.GoToRecord acForm, "frmApplicants", acNewRec to acNext instead of acNew and that seems to have...

If I close the contacts form before adding the new record to the apps form then the code can't reference the ContactID field for the If/then statement. Any ideas on how to adjust the code to make it work properly?

I have a module that runs when I check a checkbox that adds the existing record to a second table (1-1 relationship). It works just fine except that when I return to the master form, there is a new blank record that has been added after the one that I checked the box for. Any ideas why this is...

I have a main form DriverID Date Payments Charges Total (=[Payments]-[Charges]) Charges are logged in the form's datasheet-subform where they are totaled in the subform's invisible footer. I'm populating the Total field in the main form by calling the subform's total value using ...

The hotfix did it! Thanks for your time!

already tried that thx

I've also tried re-creating the table that is the row source to no avail

Yes, I had been trying to mess with all the properties to see if it changed anything and must have forgotten to set the decimal property back. I can make a selection in the combo box (even though I can't see what I'm selecting) and it puts the selection into the text box as expected, I just...

The db you posted still does the same thing; all I can tell that you changed were the column widths so as to hide the key field. While that is my ultimate intention, the main issue is that the ingredient name field is still blank. Also, for clarification, none of the combo boxes are cascading...

The "ingredient name" should be showing. In the Ingredient combo box on the form only the ingredient ID shows up in one column; the other is blank.