Search results for query: *

I had two databases on our server, one for the users and a second for me to work on updating the user database. They were named differently and I (so did everyone else) thought it was apparent which was for which. BUT, today I find out someones been entering their invoices into my database. SO...

I'm having some problems setting little internal control type procedures for a textbox in Access. I have a textbox that is ONLY visible if a certain date is entered in another textbox on the same form, I need this textbox to be required when its visible. (Ive asked this question before). So...

I have a hidden textbox and I'm trying to make it "required", but only if its visible. I used the Len argument, heres my code: this is in the BeforeUpdate event If Len(Me.Processing_Comments) = Null Or 0 Then MsgBox "Please Explain Yourself" Cancel = True End If I...

In my form I have an InvoiceDate and ReceivedDate text box. In the ReceivedDate_LostFocus event I have this code: If ReceivedDate < InvoiceDate Then MsgBox &quot;Enter a Received Date that is later than the Invoice Date.&quot; ReceivedDate.SetFocus ReceivedDate.Text = &quot;&quot; End If The...

How would I go about making a textbox required?? but only if a certain criteria is met and the textbox then becomes visible in the form. Should i just make it required in the table?? maybe a validation rule?? Or should(could?) this be done through coding? Maybe something in the GotFocus...

When i try to open a form, click a button or initiate any of the Lost_Focus events, i get this error: The expression (On Load, On Click,etc.) you entered as the event property setting produced this error: Procedure declaration does not match description of event or procedure having the same...

I have a button that adds a record to a field that has the No Duplicates indexed property (but its not a primary key). So when i click it with a name thats already in that field i get a MsgBox saying: You can't go to the specified record My question is, is there any way to customize that...

Hi, I'm kinda new to VBA and I'm not quite sure where(or how) i should go to fix an error. I'm running code that dims a variable as a &quot;QueryDef&quot;: Dim qdfDynamic As QueryDef and then equals the variable to the query approveddate: qdfDynamic = CurrentDB.QueryDefs...

hey, i have a form(with 2 unbound textboxes asking for beg and end dates) that sets the criteria for a crosstab query(which defines a report). In the query i setup a new field with the same field name as the column heading, from there i added a WHERE clause and in the criteria i typed this...

Hey, I'm working on a report that calculates three values (total #, total $ and avg process time). To do this ive set two crosstab queries to get the first two values and a select query to get the avg process time and link the other two queries. As i was doing this, i ran into hell. For some...

Perhaps I'm not doing something right BUT ive noticed that when i setup an if statement or some type of &quot;validation&quot; in a form, i can still bypass it by entering the data in datasheet. Is there any way to get the table to read the form validations?? Can you even use VB with the...

hey, ive been trying to figure this out for two weeks now and have decided that i do not have the knowledge that is necessary to figure this out. (this is the third forum I post at) I have a report setup that lists every vendor and their respective information categorized by month, so e.g...