Recent content by bjt52

Hi, I have searched the forum and found others have had this problem but I have not been able to find a solution that will work for my situation. I have a database that I have been using for a few years and it is working great. Do to changes in business needs I redesigned the database and I...

I hope this is the correct group for this question, if not I hope someone can direct me to the correct one is.. I have a co-working that is running Sql Server on a desktop and she has 3 tables that are extremely large. The files are so large she has no disk space let to work; at the current...

Thanks!

I have a query that totals items by the customer_account and another that has all the items. What I need to do is join these 2 queries together so that the total is at the top or bottom of the detail. I tied to use a union query but I only have 2 fields in the Total query and 15 in the detail...

Thanks Jerry

I forgot to add, the user uses the shortcut menu to apply filter to the subform.

I am trying to set up my database so that the application window is minimized and only the forms are displayed on the screen. I am using a macro RunCommand=>AppMinimize to Minimize the application and I set the forms Pop Up property to Yes and this part is working fine. The problem is I lose...

Jerry, I did run it from the immediate window and the mdb is on a remote machine. That is why i not sure what is wrong..

Jerry, When I try ?MappedServerName(CurrentProject.Path) complier error: Sub or Function not defined.

The last not was to Jimmy not Jerry

Jerry, Thansk.. This is a good ideal for the local machines but I have remote users and the database will be one a server that dont have access the the Root Drive.

Jerry, Please excuse my ignorance for I am a novice at VBA and I need to ask a few questions. But first let me explain what I am trying to do. I am trying to write a routine for the Onload Event of my splash screen to verify that the copy of the database is located on specific server and...

PHV, I did not see your suggestion, but it works.. Thank you.. Remou - Thank you for you help the great tip for using Debug.print

It returned nothing

Remou, This is what i did with the Val function strComp2 = DMax(Val("orderid"), "order") + 1 I have gone from EN-600114 to EN-1-005 have i put the Val function in the correct place? Thanks for the suggestion of using Debug.Print, i like that feature.. I am a novice at VBA and really appricate...