Search results

thanks a lot for the imput guys, I will look into this further and see if i can get update rights to the external table. Cheer

I'm having a problem updating a form. The query from the form is based on two other queries, one of these queries is based on a table from an external database. I want to use the Form to populate only data on my own database using a checkbox with: If IsNull (Me.ReceiptDate) Then ReceiptDate=...

Thanks smart, it definately seems to like your code better :) I was thinking about using case, but this will do for the time being while I learn a bit more vb Thanks again guys

Cheers a lot mate, finally got it to work :) Turns out the problems was data in the original tables either missing the full stop or was blank, I've made this field compulsary now. Wasn't much fun wading through thousands of records though. This is my first db so I'll make sure I learn from it...

Hi I'm a definite Newbie for coding (as you'll see in the example below) I am simply trying to get an output into a Label when certain criteria are met in a form. However, the code below does not work and I can't figure out why: Option Compare Database Option Explicit Private Sub...

Used your suggestion and it calculates the expression perfectly :) The only problem I have now is I cant get the query that links the two queries to work. I've tried everything and it keeps coming back with the "invalid call procedure" message. This is the SQL: SELECT...

Thanks a lot. I have tried this and it works to some extent but I had tried to simplify the problem in an attempt to explain it clearer The fields I use are as follows: StudyNumber (full name) which is in the format 06PJ32.512086 TA (first name- I said surname by mistake) =06PJ32 I tried to...

Can someone please help with the following: I am trying to join two tables in a query. One of the tables has only the fullname while another has only the surname (this table is imported from an external database). I need to be able to match the two tables up. Can anyone please suggest how to do...