Search results

Fixed up good. The orginal problem's been fixed. Thanks for the help. http://www.access-programmers.co.uk/forums/showthread.php?t=106630

Fixed. Thanks for the help. http://www.access-programmers.co.uk/forums/showthread.php?t=106630

I have a DB that other units are using. Part of the db includes an 'archive' function in which old records are appended to an archive db and then deleted from the running db. Since the other units will have various file locations for their DBs, I started searching on how to fix it and came...

I did that, but it's still not updating the info for new entries. I can't even find the specific code that tells that label what to show. There's a lot of public functions in modules and even more code in each form, but I can't find exactly where it gets its info from. I found something that...

I tried it, but couldn't get it to work. I also can't seem to find out where to fix this thing, either. Sorry.

Well, I finally got it all worked out. Thanks for the help. I'll make up a sample db for this and post it to the Sample DB forum. On Error GoTo Err_Command0_Click Me.Refresh '--------------Main Table Append-------------- Dim qdf As QueryDef Dim strSQL As String Dim ServerPath As Variant...

I'm still learning about putting SQL in VBA, so I tried both solutions....Both worked. Thanks. Learning curves can be steep...:rolleyes:

well...for those of you who've been following my recent problems, thanks for the help. Things are going well...but I'm back with another question. I was able to get the append queries working in VBA w/ the destination db as a variable. The next step in my db is a series of DELETE queries. I...

Updated Attachment Here are the updated DBs.

It's working, but...DoCmd.RunSQL??? Well, I have this thing pretty much figured out, except I couldn't get the SQL to run. So I ended up putting in a DoCmd.OpenQuery for the built-in "X" query. This works alright, but I would like to do this properly. Below is the code as it works now...

I probably won't be able to check it out today. Give me a bit and I'll get back to you, whether I find something or not. Don't wanna leave ya hangin'.:cool:

Sorry, I sure don't. It stands to reason that there should be a way to search for files, and if there is a file then return a value. Then maybe use something like If IsNull nameofsearchstring Then...end sub. Or maybe you could set up a loop function with the loop counter as a variable that...

That's kinda what I'm in the middle of right now. I'll probably end up working this through the weekend. Tomorrow's gonna be a busy day at work. Thanks again for your help. I'll post again when I either make new progress or new problems.:cool: TestQry SQL: INSERT INTO [Main Table] (...

Wow! That's a pretty neat db:) I entered Me.Refresh in frmGuest.txtLName's AfterUpdate event. I entered me, m1 as a new guest and it seems to work w/ the other forms, but I'm sure you want to dig through it yourself as you are more intimate with the ins and outs of your db. Hope this helps.

Can't you just put more of the same lines of code in? You know, just basically copy the code you already have, change the necessary info for the new file and the new table. Private Sub Command1_Click() DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, "updates_temp_tbl"...

I just did the Immediate Window "thing" to view the SQL produced by the VBA. Is there a way to do the exact opposite? That would cure a lot of problems.

Oh. I see that now.:o

Is your log-on form unbound? If it's tied to a table, for instance, you should be able to look back to the latest entry for the proper password. If you don't want to go through the trouble of looking for the latest entry, have the form created in such a manner that the user can't navigate...

Thanks for the tips. I'll try working on the SQL and see how that works. I realized about half-way through building this database about using spaces in names for Access. I can't go back and change it, however, because the database is built and in use. I'm afraid it would take to long and the...

The 'end sub' is in the code still, I just posted a sample of the change in the code. I'm thinking I might create an unboudn, invisible field w/ a small tied function to it so I can use that value for a select case. I.e. I'm thinking about adding a bit more code to one of the AfterUpdate...