If you are running a pass through query to an SQL Server try this: dim qrystring as string dim q as querydef 1) for a string variable - qrystring = "Select *...
Kathy I'm confused. Are you appending a new record or updating an existing one? Regards, Bill Mosca Founder ... From: MS_Access_Professionals@yahoogroups.com ...
Hello Greg, Wednesday, March 29, 2006, 10:51:34 PM, Greg wrote: G> Is it possible to change table field lookup properties in code? Maybe going to far in code....
Jim That's really not a strange behavior. All windows applications operate that way when there is a parent and child forms floating within it. This is called a...
(This tip refers to Access 2000. It will work for most versions of Access, but some of the steps might not be the same for all versions.) This one is was...
That should have read "you can enter docmd.restore in the on close event property and not be bothered with strange happenings." What I was trying to point out...
I need to append an additional contact date to the Response table. The problem is that the best way to select the records to update is by using the same fields...
Kathy, there seems to be some confusion of terms here. You append records to an existing table, not to existing records. To change records, you update them....
OK, I THINK I can see where names would need changing but where exactly do I have to put this little code....sorry, you went a bit beyond my ³query² ...
Kathy That query should run if you use SecContact as the date for the second email. It's not a function. It's just an alias for the date that is going into...
It sounds like your table format and relationships to other tables needs some work. You might want to post the table names and the fields of each and describe...
Hi yet again, Jim, You're the head of PLD, then? Yours is the only town I know that has two electrical departments - our water plants had lines from both of ...
I have two tables that I want to combine using a unique key. I have the relationship setup. The thing is I have a "notes" field in each table and I want to...
Hello group! I have the following question and I would greatly appreciate any help I can get. I have report with several check boxes and fields with...
Here's a brief summary of the important tables and field names: The primary table is "BridalDatabase" and it's a record of our marketing of dry cleaning...
I have the following query that I would like to put into a chart. However, I see where I can only use 1 series. How can I make it to where it shows ...
Kathy Here is your query. It will add a new record for each Bride who was contacted on 3/9/2006. The new records will have a contact date of 3/27/2006. Change...
Sounds like exactly what I need...now I just need to know where to put it...Iım only familiar with the standard design view query. Havenıt typed anything...
Gabriel You will have to code for each control in the section that it is in. Here is an example of hiding all checkboxes in the detail section of a report if...
It's pretty easy, Kathy. Open a new query in design view. When the box that shows all the tables opens, close it. That will leave you with an empty querlyk...
Thanks, Bill. I would have responded sooner, but have been out of town for the past two weeks. Thanks for the advice and for the sample! Lauren ... ...
I want to help the managers identify orders they can ship early, to free up warehouse space. Database is mostly straight forward - orders, production,...
Adam I just tried the database in Access 2000 and I got the same error that you got. It must be because the sub forms are actually crosstab queries an dnot...
Thanks. Upgrading isn't my choice, and may not be necessary. I've created a work-around by designing crosstab reports with stable field names, then a form...
Hi all. I am wondering if it is efficient to generate a sql statement in code and save it as a query before returning a search result? I need to base another...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
