Search results

Could you possibly give me the Dcount code I should be using and where I should place it? I was using the Dcount function, but if the query had no results it wasn't showing 0 on the form it just showed a blank form. I am stumped on this one. I am also attaching a 2000 version of the database so...

I have created a query to count the number of records that are "Pending" over 3 days and I am putting the results total on a form. This is working fine when there are >0 records found, but my problem I can't seem to figure out is how to get the form to display "0" in "Text5" when NO results...

Does anyone know how I can get the right-click menu working with a pop-up form where the database background (gray area etc.) is minimized (using the command AppMinimize). See the attatched image. I really need to get this working mainly for "Copy" & "Paste" functions. Please help :)

Patty, This problem used to stump me as well, but I did some research and got it figured out. Here is what I use for code using Yes/No button. (In my case I use it for the "Delete" function, but you should be able to adapt this code to fit your needs. Hope this helps: Private Sub...

Is there away that I could have 1 select query capture the information I need for multiple years as opposed to having to create a seperate query for each year? Here is my code: SELECT [Application Data - NE].Year, Julian.Calendar04, [Application Data - NE].CCN FROM Julian INNER JOIN...

That would be the assumption, but the number of queries could change in the future (if I am asked to create another query type report that is)

How would I write code to know which query to use? I think that this method would work :)

I had thought of that except If I use a form I need it to be able to handle which ever query is being selected.

Is it possible to make a query Pop-up? All of my forms are set so the Database background is hidden and they popup. I haven't been able to figure a way to do this with a query. Any help or suggestions would be great :)

Hmm that is weird.. It works on my home network as well. 7 computers (all with XP S2) and none in which I had to enable.. maybe I got lucky.. lol. Net Send is great at work when people don't know what it is and you send them a scary message.. lol :)

That is not necessarily true. Our company has XP SP2 and netsend works fine across our network. Maybe it is disabled at the administration leve? This also works on my home network as well. I think Net Send would be better than e-mail, because the e-mail method can get complicated; especially if...

Thanks for the explanation that makes more sense now :) I am happy to have it working properly now, because it just helped me figure out another problem I was trying to solve.

Perfect! :) That fixed the problem. What is the difference between the original method and adding the "DAO" before .recordset?

Ok well this all worked fine in my test database, but when I tried to move it into another production database I am getting "Runtime Error '13': Type mismatch" what am I doing wrong now? Private Declare Function apiGetUserName Lib "advapi32.dll" Alias _ "GetUserNameA" (ByVal lpBuffer As...

That's just what I was thinking :) I seperated the function out and it is working perfectly now (in my test database..) Now to move it to the production database. :) Thanks for the help

I thought the same thing.. I was running the query straight (to test it out) Although I think I know what you are getting at. here is the code for the LogUserName() function. Private Declare Function apiGetUserName Lib "advapi32.dll" Alias _ "GetUserNameA" (ByVal lpBuffer As String, nSize As...

I have done some searching to find a method for logging & timestamping when users log in and out. I have no problems with capturing the Log IN information my problem lies with the log out portion where I am trying to use a Update query to update when the user logs out of the database: I can...

I know I am bringing this thread back from the dead, but it looks like it could be useful to me. Does anyone know if this will show all users logged into the database with all their info. Or will this only show my details? for example: I am logged into my database and 3 other users are also...

I am glad this has helped you. This method has definitely made it easier for me to complete updates without having to worry about people still in the database locking it from being modified, etc. The only thing left would be if I could figure out how to have the update utility look at the...

I think the problem in your bat file is the following line: Start "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /wrkgrp "C:\EDT DB\ED.00.23.001_WIF.mdw" "C:\EDT DB\ED0023001FE.mdb" /user Custodian1 Try using that line without the /wrkgrp "C:\EDT DB\ED.00.23.001_WIF.mdw" /user...