Search results

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...

I've been putting a few if not nulls into my current project, but I seem to be slipping up somewhere firstly I have a continuous form, only one text box and a delete button on each, so new records can easily be added and deleted, im trying to put some error handeling so that if the delete...

anybody any suggestions?

yeh, originally it was all one, but normalisation put them into seperate tables to remove repeating data still open to suggestions

hmm, ok, not sure I entirely understand..... I changed the relationship type, thanks for that, I have never even medeled with the types before, but then again, this is the most advanced database I have ever done If i open the attendance form on its own, it displays everything in the members...

all the relationships should be in properly, I did attempt normalisation! But thats another story, confusing as anything thanks for taking a look