Search results

I have a simple data entry form with 2 fields, one is bound to a backend table and the other is an ubound box. I want to save anything typed into the unbound box into a field called [Company] in the backend table. Also I do not want the unbound box to clear itself out each time a new record is...

Are there any really good Access Database Data Integrity Tools available? I do not mind paying for one. I have a couple DBs that I would like to run a tool against and see if there are any issues with: ~Data in the tables ~Possible Query, Form, Report, Macros, ect. ~VBA Code Something check...

tbl_COMPANY (lists all of my company information per client) [CompanyName] is the name of the field which lists the company name. [Active] is a Yes/No field which will be checked if a company is currently active. qry_COMPANY_ALL will show all companies and if they are active...

I need help writting a math based query. Here is my data in the table: COMPANY PAID COLOR ALCO -1 BLUE ALCO 0 RED ALCO -1 BLUE ALCO 0 BLUE ALCO -1 BLUE ALCO 0 RED ALCO -1 RED ALCO 0 BLUE KMART -1 GREEN KMART -1 BLUE KMART -1 RED KMART -1 RED KMART -1 GREEN KMART -1 BLUE KMART -1 RED KMART -1...

I need a quick fix help. I need help with a format issue at the query level. I have data that looks like this in a column Red - Policy Blue - Paperwork Red - Forms Green - Prototype Yellow - Files ect. I need to show everything AFTER the " - " so everything after the space hyphen space needs...

I have a memo field that holds a lot of data for almost every client. When I open my main form the first field that is active is my memo field however it highlights all of the current data. I would rather it go to the end of the memo field on SetFocus. So can I write some VB or change some...

If Me!Color = "RED" And Me!State= "NY" Then Me!Color = "STOP" End If This is on a report, on format. I am trying to update a field based of off information from 2 different fields. This of course breaks. The top code is correct, but I am not sure how to update the field while the report...

I am sure this should be fairly easy, but I have never done it so I am not sure what the best way is. I have a column in my DB called [INVOICEID] I have a folder on my computer located at "C:/INVOICES/" this folder is full of tiff files named the invoice number. In my database when I am...

In my query I have Exp1: Switch([Kits]=1,"1Box",[Kits]=2,"10Box",[Kits]=3,"10Box",[Kits]=4,"10Box",[Kits]=5,"10Box") I have an orders table where I list how many KITS each customer orders. Can be any number from 1 to 100. Well I use one of 4 boxes to send the orders and I am trying to get a...

I have a entry form with a dropdown for a field [CompanyName] We have alot of clients with very similar names. example: Steve's Auto Parts Steve's Party Supply Steve's Plumbing Steve's Plumbing of Boston Steve's Welding, Inc. My users have made it a habbit to select the wrong company while...

If IsNull(DLookup("Result", "tbl_HISTORY", "ClientCode = '" & Me.CustomerCode & "' AND Result = 'USA'")) Then Me.Detail.BackColor = -2147483633 Else Me.Detail.BackColor = 255 End If So this says if my client is from the USA then make my form go red. I want to make a...

I need to see all values in a date field [SalesDate] for all of this year and all of the previous year. I know this will show me all of the previous year Year([SalesDate]) = Year(Date()) - 1 But how do I show all of this year and all of he previous year as well? thanks.

I have a couple Access DBs that I want to convert to backend SQL. Are there any great step by step tutorials out there to help? After I convert the tables to SQL what is the best practice for the front end. Leave it MDB, switch it to an ADP, convert to something brand new? I just do not know.

I am trying to write a complex query filtering data from a large table and I am having problems. I am going to work on this in baby steps so I can figure out how to do this correctly. Here is my first subquery. SELECT [tbl_FINAL].CompName, [tbl_FINAL].CompLocation FROM tbl_FINAL WHERE (SELECT...

I am running 2 Access DBs in house. I am getting ready to build a new website and I want to use SQL backend on my server. I cannot convert the access dbs to sql for various reasons. So is it possible to have a SQL Express Server running on my hosting server and have Access Database in-house...

I have a form that opens when the database is opened. There is a button called "btn_GO" Right now I open the database and the form will open. I then manually click the button. It does everything it needs to. I then close the DB. Can I tell the form to click the button for me after it opens...

I have a field in my database called [RecordDate] which is a date & time stamp. In my query I have ">Date() Or Date()" to find all tests from today. Q1.) Is there a better way to write this? Q1.) I want to remove the time stamp from the result for this query. I need to total a column and...

In my system it shows when my users lon in with a date/time stamp. examples: "12/9/2008 9:00:27 AM" "12/9/2008 8:50:58 AM" "12/9/2008 8:48:35 AM" ect... I want to write a query which will give me a count by day then hour. I want the query recordset to show me something like this: 12/9/2008...

Access 2000. Here is my VB thus far. Option Compare Database Private Sub cmdBUTTON_Click() Dim sSubject As String Dim stMail As String Dim sDocName As String sDocName = "rep_CLIENTS" 'message subject sSubject = "Here is your bill. Thank you. dated " & Date stMail = DLookup("[ClientEmail]"...

I have a form with a subform. When my user types in a bar code in the search form the subform will then show the result. My user then has to go down into the subform and check a box [Rcvd] and then add todays date into [Rcvd_Date]. Then they go back to the main form and search again. I want to...