Search results

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

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

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

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

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

Hope I can describe this well enough. I am creating a DB for a youth organisation (Air Cadets), details of which are stored in tblMembers. They attend twice a week, each of these days is called a parade and on each parade certain members are given a duty, so the date of the parade as primary...

i have the following query statement: intext: IIf([calllogs]![InternalCall],"0","External") in "InternalCall" there is either a "0" or a "1", these represent external and internal calls So I want to turn the "1" and "0" into "internal" and "external" I've done half of it, but I can't use an...

Just been searching around, found a few posts of uppercase questions, none that quite fit with mine, anyway, Basically, the data I am working on produces names as such "JoeBloggs" "FredPerry" Anyway, Im going to use a query to seperate these out into first name and last name, but, I can't seem...

Looks like this might be the one that brings me into VBA Ive got my import spec all set up, importing a text file running querys on it e.t.c. But, as soon as this DB is moved to another computer, the file name is going to be different, so for fuller automation, I need some way of bringing up a...

Right, I have a macro running that firstly imports a .txt document, then runs a delete query on the data, this delete query brings up two warning messages about the deleting of data before carrying onto the next query. I am trying to use send keys to just send "enter" twice to get past the two...

Should this statement work? IIf([CalledNumber] Like "*?*",[CalledNumber]=Mid([CalledNumber],2)) Some of the fields brought in from the CSV file have random "?" in front of some of the names, so I made this to remove the first character of the field if there was a "?" there. Maybe there is an...

Heres an example of my CSV data: 71600797mS == Tue Apr 25 12:09 [172.29.100.239] 71660381mS == Tue Apr 25 12:10 [172.29.100.239] 71665549mS CALL:2006/04/2512:09,00:00:00,013,055623412,I,349,287349,01123456700,,,0,,"" 71719967mS == Tue Apr 25 12:11 [172.29.100.239] 71779548mS == Tue Apr 25...