Search results for query: *

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...

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...

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...

Is it possible with VBA to verify the current location of the database? What I would like to do is have the database verify that it is in a specific folder before it will run. Thanks

I need help in creating a unique auto number that will look like this EN-0012345-001 The first component “EN” indicates if it is an Engineering or Sales Order. The second component is auto generated and the third component is based on what day of the week. Ex. 001=Monday, 002=Tuesday, ect...

I currently have a query that is used to update two fields on my main form, I need to add several more fields to the form and I do not want to have to create and update query for 10 more fields. What I would like to know is how to add the (below) SQL to a after_update event of each of the...

I am new at writing code coding and I hope someone can tell what I am doing wrong. I am trying to write code to require 3 fields be entered before the form will close, but it will not step through the 3 steps and when you click the ok button it will close the form. Thanks If...

I am using the code below to send out emails and it works great. The problem I am having is I have a subform on my main form that I would like to include in the body of the email. I have tried using Form!frmMain!subDetail.Form.Account but I get Run-time error '438': Object doesn't support...