Search results

Any suggestions?

Hi, I just opened the form and query and there was no value in the field on the form, and the query was blank - is there a better way to do this then?

Think I spoke too soon, I thought the 15 mins had passed but turns out they hadnt! Its still bringing up the error despite nothing being in the query and therefore the text box..

That works perfectly now! Thanks Spikepl. Is my syntax incorrect or should it have worked and yours is just a variation? Just so I know for future.

I just tried renaming the form to [SearchCall-backs] to see if it helped to no avail. I then tried [Searchcallbacks] which still didnt work.. Really not seeing the problem here!

Hi Pat, Thanks for your suggestion, I've tried this and still no luck! I dont understand, there is no reason for it not to work as far as I can see... Cheers.

Hello What I wanted was the ability to input a time on a form, and for a notification to come up at that time basically. I created a query (Callbacks - Duedatetime) that checks the database where this is stored and returns the maximum (MaxofDue Date/Time) of any times within the past 15...

Hello I have several search functions in my db but I fear this one has beaten me. I have a form, which contains a subform, which contains a subform, which contains the form 'Search Call-backs'. Within this form are several fields that the user can enter data into to conduct a search of the...

-- Forgot to add, all these queries have to have criteria against another field to ensure the correct data and only that data is being moved/deleted.

Hello So I realise I had made a completely novice mistake, about 6 of the queries somehow had the incorrect combo field in their criteria! Having resolved that, I now get the 'An INSERT INTO query that contains a multivalued field cannot contain another field' I previously had the 'An...

Okay so the onclick event runs two Macros - 'Add to inactive' and 'Delete from Active'. Both run a series of 11 different queries, each for a different table. One of the queries as an example is (they're all very similar though). INSERT INTO [AgentAssist QA] ( [Date], Agent, [Holly ID]...

Any help please anyone??

Hi Cronk At the risk of sounding dim - my FE & BE are seperate so the query will not run on the linked table. I used an auto exec to run the query to alter table. Cheers.

Hello I am already surpressing the warnings (such as are you sure you want to append data etc. etc.) but this one will not be surpressed, presumably because the macro ceases to run when it hits this error.

Hi Cronk, Thank you - I have checked all of my forms and none of them have the table bound to them, only queries which run off of that table - would that be the cause? I was under the impression that if it was via a query I would be okay. I am confident in the ALTER TABLE function, however...

Hello I have an append query that has a criteria to be regarding a certain employee, however as this employee has no records in this table, I get an error saying 'No records'. Normally this would be fine if it was only one query being ran but I have several queries running one after the...

Hello Thank you for your reply - data changes are possible, structural changes are not. Maybe I was exagerating with the word 'frequent' its just whenever I do want to, I cant! Is there no way around this :(

Hello I have a database with its backend on a network location, and every different user has a front end copied to their desktop. Whenever any user is in the front end, a table (AgentList) is read-only. Its quite a pain as I often want to make changes to the table structure and users are in...

Thank you for your suggestion, but my forms are bound.

Thank you very much. This worked a treat and I now have a perfectly working database again. Your help has been greatly appreciated by not only myself, but everyone that uses the data that this db provides as it is pivotal to our reporting!