Search results

Hi again, Ok, here's where I am, I'll give you my ideas and hopefully you'll be able to help. So the problem I have as stated in my first post is that each of my subforms have a search function to call back a table entry (to modify, edit, add, etc.). The problem I have is that when I pull...

Yes it is a field in my form's recordsource and yes, it does have the same name as the field in the table. On my form I use a text box called txtAcntQst that is bound to the Account_Number field in my table. This text box is used for data entry.

Ok, sorry for being retarded on this thing. Your code looks promissing but so far I haven't been able to use it successfully. [FieldNameHere] refers to the field name in the table right? & [YourTextBoxNameHere] refers to the text box in which the user enters the information to match in the...

Ok, I am currently working on something to fix the shared accesss problem and give each user a local copy. There has to be a way to do get my search function to work without that no? I figure it's a fairly simple matter to find an entry on 1 form without populating all the others while...

Ok the On error resume next thing didn't work... there's no more error but it doesn't search either.

Ok it is split but they are using a shared file (station restrictions prevent copying the file to each workstations). Is there a way around it? I found another thread that said something about adding "On Error Resume Next" before my search code, I was trying this out when I got your response.

Ok, new problem It worked great when I was using it by myself but now I have multiple users using my DB and they all get the following error when using the search : Run-time error 2137 you can't use find or replace now I'll head straight to goole to find an answer but thought I'd share and...

There you go, that worked like a charm! Thank you! Bob, thanx again for the effeciency tips. I will use them!

Your right, I wasn't specific on that. There is a search function on each subform. SearchID (i know it's not normalized, i'll fix that) is the name of the text box that gathers the information, cmdSearch is the button itself The main form is frmMenu, the subform is frmRequests and yes, the...

Hi again, I used to have seperate forms, each would have a basic search function that would allow the user to find a record. We have now decided to include all of the forms on a single form using tabs and subforms. The problem that I now face is that whenever I do a search on one of the...

Thanx again for your help Bob, that tutorial was great. I've always had problems with subform referencing, this guide helps alot! It now works perfectly, here's my code just in case it helps someone else : Forms!frmMenu.txtQuestion.value = Forms!frmMenu.frmQuestions.Form.txtQuestID.value...

Hi, I have a form and a subform Very simple thing I'm trying to do but my code doesn't work, would someone correct it please. I just want to copy the data that's in a text box on my subform to a text box on my main form. here's my code : Forms![frmMenu]!txtQuestion.value =...

Hi, this is probably super simple (I realy hope it is!!) but I can't figure it and can't find the proper wording to find it in google or the forums. Basically I have a form, on it a bound text box that allows the user to type in the customer's account number. There is also another unbound...

Ok I figured it out! I just didn't write my function properly. I took an example from a date I used (betweeen xxx and xxx) and applied it to my time query... Your advice helped, changing the format didn't actually change anything but it gave me an idea so thank you!!

I have 2 seperate fields in my table, one for the date and one for the time, QstDate & QstTime. The time field is a "short time" format with 24 hours.

Ok, I'll try it out and get back to you!

The problem I have is that I can't modify the spreadsheet itself. I need a way to tell access to open up the spreadsheet and enter the value from Forms!YourFormName.txtTextBoxName into cell "XX". Thank you for the button response as well, hopefully wE'll find a way. I mean worse case I just go...

Ok thank you, but that doesn't resolve my problem ;)

The word hour refered to what I thought was the function to call time in the query criteria. The time field I use does not use reserved words (qstTime)

thank you again Bob, you're a lifesaver (timesaver I guess) Now there's only 2 things i need to do in Excel, modify 2 specific cells with data gathered from text boxes in Access and the other thing is to push a command button that's on the Excel spreadsheet. Can that be done?