Search results

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.

I am trying to create a recordset that takes a date which is on the current form, and uses that to set the recordset to every record which has a date previous to the one entered on that form. Using this code in the on click event I keep getting a data type mismatch error. PurgeRst.Open "SELECT...

lol Richard Feynman was a theoretical physicist. That isn't me, at least not yet. :)

Can you stop a tab key stroke? In vb have an on exit vb sub that stops you from tabbing out of that field if a certain condition is not met, for example: If IsNull(Me!AnyField) Then stop tab End If was just curious

fixed thanks for the advice, but it was actually a data incompatability. I was trying to stuff a field in the table with something bigger than the max field size in the table. I fixed the problem and all works fine now.

I am trying to setup a handheld barcode scanner which sends its data into an Access database table. I have the Dolphin 7200 by HHP, and the program I am using is ITScriptNET Batch. The program has an automatic way to setup the collectin of the data so that it goes to an access table. You specify...