Recent content by illy2k

I have been writing databases for several years now, so I know my way around access pretty good. I have come upon a strange error though. which is confusing me to now end. I wrote a Database on my work machine which has the latest version of MS Access and SP2 for Office. I just tried to send it...

Is there anyway that you can add lets say a textbox to a form with VBA, or can you only have it as visible = false then set it visible = true?

Nm I figured it out. Never Mind

I want a user to be able to hit a keystroke combination while in my form, and have this combination do something. How can I have my form continually test for a certain keystroke combination and react accordingly. For example, lets say the user is in my form and they hit F2+Shift or something...

Ok, I have two open forms. How would I go about setting the visible property on one form from inside the other?

Ok, I have been going through someone elses Access Database to try to make it work for the client it was originally designed for. The database is coded very poorly and I have to try to figure out what is going on. They needed to change the AuditNo field in a table to AuditDate. AuditNo used to...

A little more info I am creating running a query on the click of a button to set the RecordSource of a subform to a query that is dynamic. However, when I run the query after entering something new on the main form, the query does not show the new data right after it is entered. It only shows...

I have a form with a subform on it. The person entering is entering multiple things on the main form, and on the subform I have the the recordset being set to the results of a query which is run after the main form contents have been added to the database. However on the first run of the query...

I setup a quesry which totals a certain type of sales. Though sometimes this query will be null, meaning in the specific date range specified, that there are no values. When this happens, the report errors out, in which all boxes contain #Error. Is there anyway to specify that if the quesry...

not sure I don't know how to make the rst2.Fields("SubAccount") into the thing I need to search for. It should be a string but I am not sure how to make it work.

hey dcx693 I keep getting an error at this part of the code saying, that I have arguments of the wrong type, or are out of acceptable range, or are in conflict with each other. Here is the code: rst3.Find "[SubAccount] = " & rst2.Fields("SubAccount") & " "

can you seearch a second recordset on the info obtained by the first? Lets say I wanted to search rst2 using rst.Fields("SubAccount"), how could I do this?

I keep getting an automation error in this snipet of code: rst2.Find "[AccountNum] = #" & Me.AccountNum & "# " str_Name = rst2.Fields("SubAccount") rst3.Find "[Name] = '" & str_Name & "'" The error varies depending on if I have quotes around the: rst2.Fields("SubAccount") Anyone know how...

Ok here is my code snipet: With rst .Find "[AccountNum] = #" & Me.AccountNum & "# " If .Fields("SubAccount") = Null Then Exit Sub End If I just want to see if the value in the field of the recordset rst, has nothing entered for it. For example if on the form the account# is 2...

I have seen code on how to disable the 'X' close button on the actual Access Program, but I have no been able to figure out how to stop someone from closing a form with the 'X' close button. Any ideas, or can anyone point me in the direction of a post that answerts this question.