Recent content by moorsey

many thanks for the link, will have a play with that! cheers

Hey all, Gone in a bit over my head with an access project at work, I'm sure I knew all this stuff when I was doing my dissertation. You guys helped me big time back then. Anyway... The three tables concerned with this are "hardware", "software" and "hardware_software", any one hardware...

fantastic, thanks very much for you quick responce, works fine

If qdf.RecordsAffected > 0 Then Forms!switchboard!txtResult.Value = (Forms!switchboard!txtResult.OldValue & Chr(10) & "Invoice " & rst!InvoiceNo & " was updated") Else Forms!switchboard!txtResult.Value = (Forms!switchboard!txtResult.OldValue & Chr(10) & "Invoice " & rst!InvoiceNo & " was...

thats great, thanks for the reply. The doevents worked a treat, very useful to know for the future as well cheers!!

Hi there, im doing some stuff with SQL in VBA for uni, I thought what I wanted to do would be simple, but apparantly now. Alls I want to happen is have a box on a form change to "processing" when an SQL statement is executed and then change back to "done" when it has been processed The trouble...

I'm going to have to bump this as I am also having trouble with that code i have this in my form open Private Sub Form_Open(Cancel As Integer) 'hide all toolbars (also disables right click) Dim i As Integer For i = 1 To CommandBars.Count CommandBars(i).Enabled = False Next...

ahhh that cracked it, makes sence now, thanks very much for your help!!

ahhh, that would make sence, I never even thought of sub-reports, never used them So I can put data from different queries in different subforms on the same form? I have created two of the queries I need for that, the last one I'm not so sure how to create, I need the query to show all of the...

Hi there, I have been developing a register type system, that stores who was not in attendance on any particular night I want to put different members under different headings depending on if they were down or not so if they have an entry in the attendance table for that night and they have...

I must be missing something here, following my other post, I have fixed my problem with storing attandance records by not using a composite key and by just storing people how don't attend, makes things much easier! tblMembers stores member details tblParade stores who is on duty for that...

sorry to bump this, but I'm really struggling with it:confused:

Hi, thanks for the replies, you were both right, I used SaveAsText acForm, "NameOfForm", "c:\NameOfForm.txt" and had a scan through, found that is was still in the query even though I must have checked 10 times!!!! It had Expr: at the start of it, so I had just looked over it thinking it was...

thanks man, thats a big help to lots of other things to, cheers!!

Im quite a way into this database, and I decided to bin one of the fields that I didn't require anymore, so I deleted it from the original table and on all the forms it was referenced on (including the queries behind them) but every time I open my main form, it comes up with a message box...