Search results

Is there a function that acts like a Msgbox, but instead of prompting the user to click "OK", the user will have to choose "Yes" or "No"? Answering "Yes" would continue the input, while answering "No" would undo the input. My problem is that a primary key (or multiple primary keys) aren't...

I've got the exact same problem. I'd love to hear feedback. My plan is to create another form to capture the information and write code to insert the data into all of the necessary tables. The user will simply click the "Add Record" button, but instead of assigning the add record command to...

Thanks CyberLynx. I've removed Design view options from the users. {fingers crossed} Rabbie, if the error comes back, I'll post the DB. Thanks for the offer!

George, You are probably right, hence you are a VIP & I'm not. :) I'm not familiar with all of the built-in functionality within Access, so I tend to rely on code to make my DB's work. I've never created a look-up table, so I'm going to do some research and teach myself how. This forum is a...

Using the following code posted by Kempes: Select Case test_expression Case condition_1 result_1 Case condition_2 result_2 ... Case condition_n result_n Case Else result_else End Select How would you handle null values? My case else doesn't recognize null values, so it errors out. The...

Randomly, yet regularly, my form won't open properly. I receive a 'syntax error in expression query' for the input mask I use for all of my date fields. When the error occurs, one or more of my subforms won't open. I've found that the error goes away when I delete the sorting criteria on the...

Form.Filter = "User = """ & User_Select.Value & """" That works like a charm. I wasn't adding enough quotes originally. I'll make sure to spend more time troubleshooting before posting again. Tight deadline to get this DB up and running has me scatterbrained.

I added a combobox called User_Select where the user can select his/her name. Now, I want the code to filter the form based on the User field so I updated the code to read: Form.Filter = "User = " & User_Select.Value & " " But I don't know what character I need to place after the = and...

I want to filter a form using variable input from the user. I simply want the user to be able to input his/her name and the form will filter only records that apply to him/her. I'm assuming the VBA starts like this: Form.Filter = "User =" & How would I complete that statement or am I...

Thanks Neil! I had a feeling that was the case. The fields that I wanted to copy are pretty common and can be found multiple times in each table. However, as I was trying to identify a way to apply the primary key so that it worked and wouldn't disrupt any of my data, a programmer that works...

I realize this thread is old, so I hope someone keeps up with the old posts! What criteria is used in the Append Query to only transfer the active record on the form to the other table? I have 2 tables and 2 forms respectively. Table 1 is preloaded with thousands of records, while Table 2...

Thanks, Banana. The concept of what you wrote makes perfect sense to me, but I wasn't able to get it to work. I think something else is rotten in Denmark, though. I tried another workaround that should absolutely work, but the data isn't storing in my table. Here's what I'm trying to do...

I'm looking for suggestions for what event I should use to trigger the following procedure: Private Sub Net_Calc() [Net_Remaining] = [Over_Under_Audit_Findings] + Nz([Cash_Flow].Form![Transaction_Subtotal], 0) End Sub [Over_Under_Audit_Findings] & [Net_Remaining] are on my main form...

Thanks all! I got it to work. As it turns out, I named my Module "DateBucket". Once I changed the name of the module to "Functions", it worked fine...with the exception of Null values. I had to create a separate field with: IIf(IsDate([Completion_Date])=-1, DateBucket([Completion_Date])...

I'm a beginner (at best) to writing code. I have a "Completion_Date" field in my form. However my work months are not based on calendar months, so I want to populate another field with the work month based on the date that was entered in the Completion_Date. I'm using Access 2003. Can anyone...