Recent content by harrop11

Hi, I have tried looking everywhere for this but I’m not even sure how to word it as I’m not getting anywhere. What i have is a basket type page which shows items in a basket. These items are shown by filtering on an order number to show only the items on this order. I then have another...

Told you it was something stupid. This is one of those time when you feel like a complete nugget. Thank you very much, i'll now have another go. It's not like i've spent much time on it . . . .. . . . . . .

Microsoft office access 2007 (12.0.6211.1000) SP1 MSO (12.0.6213.1000)

I think i might have found what may be causing me some problems. I entered the following into the code builder in the on click event part: Private Sub Command9_Click() MsgBox "testing again" End Sub When i click the button it looks like it's trying to do something as it sort of sticks for a...

Thanks for responding Rabbie. I thought this would be the case but upon trying to do this i found a different issue, http://www.access-programmers.co.uk/forums/showthread.php?t=173510

As you will nkow know i dont really pretend to know anything i'm what i'm talking about but i did know that the Me keyword was a shortcut to the current table. I have been trying these on the onclick event of the button. I have tried the format you have suggested and many other combinations...

Here is a copy of the database. I want to add a new record to the frm_newvehicle and then transfer the registration number of that new entry to the frm_fulldetail where a new incident can be created. Anyones input would be great.

Could somebody please shed some light on a problem i'm having. Bassically i want to create a record in a form which only has fields from the one table in it. The problem i'm having is now once this record has been created i want to be able to copy the primary key which i have just created to...

Hi, I'm guessing this one isn't as easy as i thought (hoping) it might be. Well thanks anyway, i'm guessing i'll have to take a different approach.

Here you go. While your in there i need some way of a query diplaying if the registration has been logged under an incident in the past 24 hours but thats just for browny points. Thanks

Hello, To say the least i am very much a beginner to access and while creating a database for a college assignment i've come accross a small problem which i cannot for the life of me find a solution. Here it goes: the database consists of 3 tables which are joined by the central table which...