Search results

Well my solution was to go back to the original plan found in the other post. Since I had time to think about things before you where nice enough to post I had made changes by removing the Join tables. I had thought that I might not need them. But as it turns out I was making my situation...

Thanks for looking, you just helped me with my other question :)

Ok I think I just got this answered from my other post lol >.< I might have had it right from the start! I hate it when I change something and then make it worse! TO see that post please look at http://www.access-programmers.co.uk/forums/showthread.php?t=204309

Ok I know this must be simple but I just can’t get it. I have a table 'Audit' and it has a bunch of fields including one to select the 'Auditor'. I need to be able to select more than one Auditor for each record in the Audit table. I thought that I could use a Auditor table and just setup a...

Ok this is a simple database but I want to double check my design before I move forward. We have a set of 'sites' that’s audited 4 ways: · Qualification · Surveillance · ForCause · Capacity Also, please dont mind the fields in the tables, I am moving from excel to access and I need to...

Thanks Rabbie and Bob!

Ok I have a simple SQL query question. SELECT tblSMRForm.CancelledReason, tblSMRForm.COI FROM tblSMRForm WHERE ((Not (tblSMRForm.CancelledReason)="Collection successful")); This will prevent any records that have "Collection successful" from showing up but for some reason its also not...

Ahh, good tip! Thanks!

Hey guys, I just put together my first Function :D Anyhow it works just fine but the email that it sends out can look kinda messy (see the quote below). Any tips on how to make the code not show the Null Strings when creating the emails? Also any genral tips on my code? I know it works...

Apparent issues with the code?

Hye guys Any idea why this bit of code might not import into a table? I don’t get any errors and all the values are correct, it just simply will not add the data into the table. ErrHandler: If Err.Number <> 0 Then CurrentDb.Execute "INSERT INTO [tblErrorLog] SELECT """ & wbk.Name...

YOU ROCK!!!! All fixed!!! I always forget about the ref's

Set rst = CurrentDb.OpenRecordset("SELECT [COI] FROM tblSMRForm WHERE [COI]=""" & wks.Cells(lngStartRow + 2, 3).Value & """", , [dbSeeChanges]) I get a type mismatch on this line in the live database but not in the test database.... Not sure why :confused:

Well the way the script should work is: Loop a bunch of Excel files get the data Import it into 4 tables (tblSMRForm, tblQandA, tblCategory and tblPersonnel) If there is an error with one of the files (like a date is wrong) then add a record to tblErrorLog for manual review. On my test db...

Ok I am not a VBA guy, I can understand a good amount of code but I need Google for the most part :p I had this bit of code created for me to import a bunch of Excel documents into 5 tables inside access. The problem is that it works on a test database but not on my working database. I...

Well it looks like my code is fine, it was just a matter of me trying to use a label instead of a command button (I like the way labels look) Anyone have any idea why a Label would create these issues?

Before I start, I am NOT a programmer, but I can normally Google my way past most issues. Ok I have two issues; I am working with the code attached below. I want users to be able to hit a command button and a report will come up either filtered based on the Combo and text boxes on the form...

Hah, sorry about that I guess when I said all cells I meant all cells in that field :p Sorry about that But thank you for getting this to work!!

Everything in in SQL so thats hard, I can give you a export of the needed tables and report. Will be back in about an hour

Just did that, same thing. Is it possible that my Weekdays would be formatted incorrectly? Jeez I thought this was going to be simple lol.