Search results

Thank you!! That worked perfectly :)

I have an insert statement that allows all my information be saved into a table. The only issues is that it will not take an apostrophe. so when i enter O'Donovan or anything like that it crashes. Can anyone help me? CurrentDb.Execute ("INSERT INTO TRCTable...

Hi All, I am new to Access and found this forum great help during one of my last issues. I built a small Access database for a Team at work which collects the following information. Name serial Number Date entered Lead name I have also made this table searchable by serial number. So a...

Thaks for helping! For the control source for each textbox I have the field name in the table where the info is coming from. Then in the form i have the Record Source set to that table. Is that correct? The information coming back is all correct.

Thanks for the advice but unfortunately I took it out and it didnt work.. would you believe it was actually there as i thought that might stop it.. I thought it might be happening because it had to search through the whole table but then i deleted a load of rows to make it a small table and it...

Hi There! I need help again, this is driving me insane:eek: I have three Tabs. On the first Tab I enter information and select submit. This adds the values to a Table. Fine. The second Tab, searches this table based on a value i insert into a textbox. However, when i select search the whole tab...

Thank you for all your help! I was wondering could someone advise me on error handling. All My application is doing is inserting information into one table. And viewing this information. Again I am new to this so sorry if i sound silly! View Information code-- Private Sub FindNext_Click()...

Figured it out! The macro was to insert the date and Time of the last time the record was modified.. Turned out though that included Viewed so was useless.. thats my next task.. but for now I got it working, thanks a million! Dim message Set RST = Me.RecordsetClone ' new code...

Thanks for the fast reply. I just tried that and the search function just stopped working altogether. I kept getting my Msg Box saying the number is not there. Any other ideas? Thanks again!

My user enters a value into a text box and selects search. The first record matching this value is returned. However I want the user to be able to continue selecting search and keep hitting records with this value untill the end. Can anyone help? im pretty new to this so any help people can...