Well actually, never mind -- I took the easy way out and simply turned
my query into a stored procedure and called that from the macro. I
would have liked to have kept the SQL strings within the Excel books,
but I guess I can't have everything...
Re: trouble with form in C# ... Would you mind if I send you my *.asp ... using a stored procedure.... > typically do a query and only insert when needed. ... > 3) Do a query for the nick first.... (microsoft.public.dotnet.framework.aspnet)
Re: Auto checkbox check on button event ... keeping in mind it is a continuos form with about 35 records. ... > If your run query button is using code, add this line to the On Click ... > If you are using a macro when you click the button add this line in your ... (microsoft.public.access.formscoding)
Re: Date changing to current ... Running a macro that opens a query doesn't actually do anything with the ... Select the macro in the database window and right-click. ...Private Sub Status_AfterUpdate ...CompletedDate = Date ... (microsoft.public.access.forms)
Re: noise words, @@ERROR, and stop and resume indexing ... > Noiseword varcharNot Null ... > the data from the noise file to the noise_words table. ... >> A clause of the query contained only ignored words. ... >> into query analyzer before starting the stored procedure.... (microsoft.public.sqlserver.fulltext)
Re: Combine Multiple tables into One Master table ... You can use a macro with 3 TransferText actions, one for each table, to get the data imported into your Access tables. ... the Open event of a form which always opens when the database opens - but then what if today's import has already been done. ... And then make an Update Query to add the data to the other fields from the related records in the other two import tables. ... (microsoft.public.access.macros)
