Recent content by Smilie

The database is on a network drive and is being accessed through a shortcut on the desktop. There are multiple users in it at any given time. It has not been split (yet). The database has been around for years and it is only since I created this new form that this has become an issue. It...

I just re-vamped our main form in the database. Now my users are complaining that the database will randomly close on them. It seems to always happen if they allow their computers to fall asleep with the db open but it also occasionally happens while they are working. There are no errors...

If you use a vlookup function you could see if there were any differences. Put the formula in column C. When it comes back #N/A, that means that the column B # does not exist in column A. You could put in a reverse one to check the other way around if necessary. =VLOOKUP(A:A,B:B,1,FALSE) A...

Problem Solved I figured it out. I was right. It seems that I can't do a subquery with multiple fields. I had to break that query apart and it seems to work now. Here is the solution: select k.site_id, s.name, st.date_opened, (select concat(c.name_first,' ', c.name_last) as User from...

SQL Subqueries Can anyone tell me what is wrong with this complex query? It works fine without the highlighted subquery. The subquery works fine on its own. But they don't work together. I think that I might not be able to call multiple results from a subquery but I'm not sure about that...

I need to run a report via macro that runs once a month on the first business day of the month. I can't figure out how to specify that condition. Seems simple, but I just can't think of the solution. Any ideas? thanks in advance.

Another solution That sounds like a good idea. What I ended up doing that worked is that I opened a form with a filter (combo with a "filter" button) that "On open" opened my multi-paged report behind it. When I filter, it turns into a 1 page report. I also have a button on my form that is a...

Please??? Is my problem unclear or have I stumped the masters? Can someone please throw me a lifeline here?

Thanks. I actually ended up doing it a different way. Here's the code in case it will help anyone else. This allows the user to enter the date portion of the file name. (They are always IV010105.dbf where 010105 is the date the table was created.) Private Sub cmdImport_Click() On Error GoTo...

Thank you, Thank you, Thank you! I have been struggling to figure out how to import or transfer a database into my current database. But I also needed my user to specify the file name. I was able to manipulate this code to work just perfect! :) Thanks again! :D

That sounds like a great idea, but unfortunately I don't know how to do that. Since I am self taught, I know only enough VBA to get by. If this is something that you have an example of I would love to see it or if you could offer some general guidance of how to go about it. thanks!

Is the query/table that your combo is based on bound to the right field? It must be bound to the same field that the main query is looking for. Just a thought...

Thank you! Thank you! This also happened to me but only on computers with Windows 2000...not XP. The service pack is supposed to fix it, but also deleting some of the body text helps. Who woulda thought???? :rolleyes:

If you really want to append a record to a specific table only when you click a button then you could do this with a macro that has an OpenQuery command. The query should be an append query, not an update. However, I am wondering if you are actually wanting to put this record in one table or...

I need my users to be able to open a macro in design mode because they are using the transfer database function to bring in a report that changes names every month. So, they need to update the source file before running it. Is there a way to open a macro in design mode besides doing it from...