Search results

I need some help with DMax multi user. I don't get a PO number and when I click on my subform I can't change the values because it says I need to add multi user. Also code that Chris O and RainLover had references additional fields which I don't have. I only have the one field that needs...

I'm looking for a way to fill out 5 records in one row in a table at once. I want to update a supplier and price per unit for supplier via a form. I have price per unit 1-5 and the price will be the same for all 5 records. Is there a way to do this through append or update query and if so...

If I filled out a form in my database I could not click on the record arrow on the bottom of the screen to look at past forms. I had the "Data Entry" property of the form itself set to "yes". So I set it to "No' and could arrow back to look at other records. However, this has caused a problem...

I am trying to populate a textbox based on selection from combo box. Both fields are in two different subforms within the same form. I do see the selection from the combo box fills via debug. I don't see a value in the textbox. This is the code I am using: Private Sub...

If I save the form it's not going to save all info to the table because there are drop down lists that are chosen from. I was wondering if I should save all information to a different table then print the PO's from a report. If I am way off track please let me know. Last but not least I did...

Trying to get a total on main form from records from two subforms. I'm coming up with Run-Time error 2450 Microsoft Access cannot find the referenced form 'tblitemlist subform'.

Right now I have a flat database with too many unnormalized fields. I am trying to figure out how to break down the repeated "QuantityOrdered" 1 through 5. "QuantityReceived" 1 through 5. "RequestedItems" 1 through 5 and "Price" per unit 1 through 5. I'm not sure if they go into the same...

I have the date set in the table and it shows up fine in the tblDate cell but doesn't pass through to the txttblDate in the form. I did have it working just fine until I rebuilt my database

Started a new thread: Rebuilt database and still need help with auto number for multi user form. The code I have works for single user but not multi user. Also if someone opens the form and closes without adding anything to the form the number is used with blank record. This is what I have...

Hello all I am looking for some help with next number showing up on form. I set tried to setup auto number in my table but my key id is setup as autonumber and it tells me I can't have two. Is there a way to get a "next number" to show up on my form when I open the form? I'm also hoping that...

I didn't create this .accdb. I've been asked to help fix the error but when I open the .accdb it gives me error 2105 upon opening it. I've tried decompile/compile (grayed out), compact and repair (which does nothing). Any/all help will be appreciated.

If someone can help me gray out one field if another field is filled in on the form. Example: If textbox containing Mass is filled in then gray out Volume and if Mass is not filled in then gray out Mass and allow to fill in Volume.

Hi All - I need some direction. I don't know to much about programing or adding code to MS Access. I need to create a report containing a specific number of randomized records from each catagory. However I do not know which way to go with this. I have tried vb coding within the report but it...

Hi All - I need some direction. I haven't programmed in years. I need to create a report containing a specific number of randomized records from each catagory. However I do not know which way to go with this. I have tried vb coding within the report but it doesn't run. I tried top records...