Search results

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

OK guys, I think I got a grip on it now. For some reason its working now, and that error message handling gave the correct results. Points for you both :)

The error I get is on this line; total_r = total_r + rst!SumOfAmount2 No I created a query to test it, i'll test it again. Just a side not, can we add in any error handling which can prove that it has a value?

It errors on this line, I thought it returned no results either, but then i copied that exact SQL statement into a query window and it returned a result, even on the same unique ID.

I tried the above cost in my application and received the following error; Run-time error '3021' No current record Sorry but I don't exactly get what you saying here "Just use a variable to store the information that you are going to put in a variable anyway:" Regards

I tried that, order it still failed, thats why I assumed it was a connection problem. Dim dbs As DAO.Database Dim rst0 As DAO.Recordset Dim rst As DAO.Recordset Dim rst2 As DAO.Recordset Dim strSQL As String Dim strSQL0 As String Dim total_r As Integer Dim total_r_inc As...