Recent content by DreamAwake

namliam, its possible in 1 query, i've posted this same question at Experts Exchange as this was an urgent matter; http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_23385218.html I'd post SQL here but unsure on their TOS

I ended up using using the replace function replace quotes and this resolved my issues.

I have attached a screen shot of my database schema. This is my scenario; There are 3 different situations when it comes to searching a quote. 1. You have a job with 0 quotes. 2. You have a job with say 3 quotes, but none have been awarded. 3. You have a job with 3 Quotes, 1 or 2 have been...

Hey Guys, I actually found the problem. If I insert say Hello World It works fine, but if I insert Hello Wo'rld is there a wade to make strings safe my sql inserting. Cheers,

I do have it in there its just the forum replaced it with a emoticon

I tried that but I was still getting the same error. Thank you for your efforts

I've been staring at this for a while and have had no luck, anyone able to assist? The error is point it too the end of the document Thanks in advanced

Thank you i'm quite sure i've got it all sorted. Your assistance was appreciated. Green Points to you..

Thanks, I have never used subforms before so was unaware of that property. It now links the PMK. Its not 100% important but when you type a value in a text box linked tot he Project table it creates a PMK value from AutoNumber. But when I type data in the subform it does not. Regards,

I would perform a query to the Employee table to see if a match exists. If theres a match perform a MsgBox.

I tried subforms but it just didn't seem to work. like I need it to reference the PROJECTS PMK but now its not going to know what it is because the tables are not referenced.

Yes its all 1-1 I just don't seem why its a problem query all tables as I do need to save data to them all from the 1 page.

Yeh thats what I thought at first too. I know a little bit about INNER & OUTER joins but tinkered a while but coulnd't get it working. Just to note there is a main table called PROJECTS which is referencing all other tables via PROJECTS PMK. When I am opening this table PROJECTS gets an...

I had this issue the other week. http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_22986113.html Idea is that you need to have the field in date/time format for this to work. then it converts Jan Feb Mar; to 01 02 03

I've got about 5 or so tables in my Back End. Now when I pull this query on the forms OnLoad event so I can save the data no forms are displaying. But if only display 1 table in the query they do show. Is there a limit I can only seem to have only 2 tables referenced at once. Thanks