Recent content by JamieW

I have a combo box uses it's after update value to filter a subform. this works fine but my problem is: When the value in my combo box does not have an attached record (yet) the subform returns all records with the first combo box's value. I would like for it to return NO records. My other...

anyone have any idea before i call it a day and release this? cheers, Jamie

Cheers bob, still raised an error but i changed it a little and it worked It Didn't like how i did my speech marks either :( DoCmd.RunSQL "UPDATE [tblPID] SET [tblPID].PIDPIDNoRev = (([tblPID].PIDno) & '_' & ([tblPID].PIDRev));" worked cheers Bob, Jamie

I built an update query that adds two strings of text together with a _ inbetween. eg field1 = Hello Field2 = Jamie after update= Hello_Jamie This works fine but when i attempt to run the code in SQL on an after update instance i can't get it to compile The SQL straight from the working...

I'm also looking for a solution for this issue. i can successfully Filter the subform using the value in the combo box, but the subform always filters with the initial combo box value; even if it loads as null. I dont understand why it is already filtered as the code is triggered on the...

Problem solved, My status checkbox needed to be in my main table instead the station table... Still would like any opinions on the new relationship layout. I understand this is probably very simple for most people but i'm just getting started. thanks, Jamie

Right, I've set up my database with new tables and relationships into what i believe to be a much better and more efficient layout. I've attached the database below. What do you think, am i on the right track? I haven't started the audit yet but will do soon. My problem is that when i query...

Thanks again Rural, I'm going to test a few methods and then post back Jamie

I think i was getting mixed up with the temp table which cannot have a primary key when copied. But, Allen brownes audit example says 'each table to be audited must have an AutoNumber primary key; ' Is this just for the sake of the Audit log? or can these be the Primary keys already being...

Right, after doing a fair bit of research on the Normalization process and relationships i have started my whole layout again. I have also simulated the audit log RuralGuy posted as an example. now, am i right to believe that to have the audit log functioning correctly, you need to scrap all of...

Thanks, i really appreciate the heads up... as i expected really. It was all getting far too complicated I'll have a good read though the examples and tutorials that you linked. cheers, Jamie

Gemma, The Checkboxes are held in a datasheet subform that is linked to a table. take a look at the .zip ^^ if you have time. Am i destined for failure this way then??

Thanks for the reply james, I am aware of that program but this really needs to be designed in Access. There will be more functionality added to this project that Microsoft Project cannot handle and also the current databases need to be imported from excel. Any other advice? Thanks, Jamie

Hi, I'm designing a database but it is turning into a bit of a state. :( I Understand that my approach is probably poor but i am fairly new to Access. and realln need some advice/help All other programs i have written have used inputs from list and combo boxes to wirte to a table. This is...

partially sorted the date entry: Private Sub Form_AfterUpdate() DoCmd.SetWarnings False DoCmd.RunSQL "UPDATE [tblMainProgressList] SET [tblMainProgressList].STN1Date = Now() WHERE ((([tblMainProgressList].STN1Date) Is Null) AND (([tblMainProgressList].STN1)=True));" DoCmd.RunSQL "UPDATE...