Search results

Hi all I am using a form with a subform based on a query, and I want a text field that as it is typed in to refresh or requery the subform, but the problem I am having is that when I press a key the whole field is selected. I could enter more characters if I use the mouse each time I press...

Hi Wayne I got it fixed. The query was including blank criteria that I had in other fields. I fixed it by having VBA insert "--Please enter a value--" into all criteria fields

Hi Wayne Could this be corrupted? How would I know? How would I fix it? Scott

Thanks Wayne (genus) I must have done that the wrong way by counting the ISBN_Number in the tbl_Each_Book table in query once before and decided it would not work. Any way I have got another screenshot of what it looks like now. It shows all records instead of just the one (Same as before) Scott

The #Error is refering to a calculation in the subdatasheet. when you click on the plus sign the #Error for that record goes away and is replaced by a number. trouble is when I select all records and click on the plus sign all records have the same quantity I am considering storing the...

Sorry, you were too quick for me. I had forgoten to add it at the time but now I have edited the post. Thanks for helping

Hi Wayne You took me down memory lane. I forgot about using OR like that, but for some reason it is not working still. (See attachment), In the attachment shows the query in design view, and a form with the fields that the query is referencing, one of which is filled in (title) and a subform...

Hi all I have a query that needs to have multiple OR criteria (See attachment to see what I mean), but I am having problems with it. It will work if I only had one criteria in, but when I have nearly all fields having a OR criteria then it won’t work None of them have any criteria in the...

Thanks Wayne, I will try that.

sbayeta: I noticed that the primary key contains the date. The two first letters, if there is a need for the same two letters on the same day it would not be unique. Also consider that the alphabet contains 26 characters, multiply that by 2 and you get 52 different entries that would be...

Hi all I am doing a database for a person and he wants a demo version of it so he can test it. The one thing I am worried about is that he or one of his friends could hack in and disable the expiry. I have been looking at sites like...

1) have a query that is based on the current field. if having problems see attachment for info on how to set criteria to a value in a text field in a form. 2) set the form to have the query as the record source 3) in your code: DoCmd.GoToRecord , , acNext me!sfrm_your_subform.requery ' or...

Hi all I have a problem with a form and it only happens sometimes. the problem is that the form when opened will not always have a taskbar button, but will still open Operating system: Windows XP version of Office: Office XP popup Set to: No Modal set to: no "Other" tab settings: All set to...

We all have a dumb question sooner or later :eek: . lol Look on the bright side, you won't know if you don't ask ;)

Thanks ken I found something on setwarning in google Thanks again, you've been wonderful

Does anyone know of a way to disable or to keep the notice from showing when you use a action query? Thanks in advance!!

Finally worked it out. All it needed was a Me.refresh I did not need a goto record because after the refresh it would appear in the appropriate spot on the subdatasheet. Why did I not think of this one? I should have earlier. Thanks again brian for helping :)

I have a dlookup to check to see if there is a match first, if there is then it will enter a value in the "ISBN_Lookup" text field. Sorry for leaving this out. Thanks for helping :)

Hi all I am having problems with this code. I works only when the right record is the first record, however when the first record is not the record with the same ISBN number as the book that is scanned, it will give a error (see attachment) Do While...

The reason why it was still not working was the On Error Resume Next line I had put in to stop it from coming up with error code because the recordset was at the destination record. I am now working on a case select statement