Search results

Uhh, I can't even go and edit the code (i.e. delete a line) without it crashing on me...

Okay thanks. I'll try that. Every time I try to paste that line in, its giving me an error and shutting down... I'll just type it manually, but why would it do that?

Okay. So what would working code look like? I'm not very experienced at VBA. If IsNull(SCIDList.Value) Then Else SCIDName = CurrentDb.OpenRecordset("SELECT table_name FROM [SCID III ListBox Names] WHERE table_ID = " & Me.SCIDList) End If?

I inherited a database that was not split (maybe this is why). I'm trying to split it and I ran into a problem. I split a version of the database that is working perfectly and then get an error on one of the forms. Obviously, splitting the database is the cause. So, the form essentially has a...

Thanks very much. I'll work on implementing this once I find a bug-free version of the database.

Hmm. I tried again to see what the error message was and it worked this time. So I now have the regular ____.mdb file and the ______ be.mdb file. The former is the program, and the latter is the data. I then ran a compact/repair on the program, and it reduced it from 60 to 11 Mb!. So I had...

Hi, I'm new here. I'm not sure if this is the right forum for this, so let me know if it isn't. I started a summer job in May, taking over as the database person here. The database is not in good shape. There are extra 'garbage' tables, I've heard the code is not very good (I'm not that...