Search results

I have two databases. 1: one Stored on shared drive and accessed by multiple users 2: 2nd Stored on Tablet PC Cdrive for field use I intend to use an append qry to to export data back into the main database following site visits and this is not a problem. The problem is: What is the...

I would like to know the best way to colour a field if a day of the week (Mon-Sund) is not displayed. Tried the between function Monday to sunday with no success, any ideas? Thanks mark

Dear All I am trying to use the sum function unsucessfully to subtract work completed values from the whole project value, if the true condition is ticked. =Sum(IIf([ValueWorkCompleted]=True,[TotalValueIncVAT]-[StatementOriginalValue)) This sould be, if the work is completed, subtract the...

I have a report I use as a statement of payments. I use the sum function to add the quotation values. Some are completed and invoiced some are not. The sum function adds all the quote values and there is a field that states invoice payment received (Yes/No value) Can I use conditional...

Dear All I have a query to find clients between a date range for the date quotes were sent. Currently when I run the query I have to enter a date past my target date to get the right results! I use a between dates criteria and want to find all the records sent on say the 19 Jan 2011. I...

Dear All I attach a screen shot of a report we use for invoices. The problem! If the client does not have a first name recorded a prenouced gap appears between the client title and surname. How do I get the text to push up if the client first name is missing. Her is the code I use...

I have two different databases and would like to import data from one database into the other. The Clients table in one database (database1) has different field names in the other client table (database2) I want to import all the client data from database 1 and currently can only think of...

I have 3 combo boxes used as look ups 1: Client ID 2: Surname 3: Company Name when you search any of the combo boxes and navigate to the account, the remaining combo boxes display the last search and not current client. I have found a way to set the form current event for 1 combo box but...

Hi All I have 4 seperate queries to extract data data from 4 seperate tables, using the same criteria each time: Inspection "date" and "surveyor name" At present I have to enter the same criteria 4 times, once for each querie. Is there a way to use the criteria once to run all 4 queries...

Hi All I have a report which is a schedule of works for a job. The schedule details each site and then the description of works in a seperate field. Each site always starts with the following: Site 01 "site name", or site 02 "site name" and so on. I want to underline and make bold every...

I have a main database and a tablet field version to capture data. If I use a query to export data from the main system to the tablet, what type of query should I use to import this data from the tablet back into the main system when I return to the office? Append? Update? System overview...

Dear All Currently every time I open the database It is disabled and I have to press "enable content" to get the system to work. When I open the trust centre and select the route I get this message" The remote or network path you have entered is not allowed by your current security...

If I am using the forum incorrectly I apologise in advance and will remove the thread. I am looking for a developer to help me set up a tablet version of a desktop system. I have developed the tablet version (for use in the field) with limited tables, forms, queries, macros and reports...

If I am using a front end and back end set up, should I install one front on each users desktop pc OR one front end that all users (5) link too. Thanks mark

Any one who has the time to help, I am trying in vain to find a way to send email to our clients, creating one email and sending to all in the database. I have found the following link and I am probably (definatley!) being thick. http://support.microsoft.com/?id=318881 I have followed the...

I have two sections of code 1: To create a new account 2: To open a form I am new to code so as you will see a little stuck. How do I stich the following code together to make it one event, as apposed to two seperate, Sorry for my ignorance! Private Sub Command57_Click() On Error GoTo...

We have a CRM management system for managing quotes, invoices, work in prgrees and so on. I am trying to find a way to get past a problems that I am currently struggling with! Problem: What is the easiest way to send a client an email using the email field on the form and attach either the...

I have a quote field, users currently click a cmd button to prompt a second pop up form, that adds one to the last quote no to create a new quote no. How can I create an event to prompt this form if the field is null? Thanks Mark

I am trying to create some code to print several reports. Currently I have three seperate queries underlying three seperate reports. I use critreria in each qery to create the report "quoteNo" I enter the quote no and the report is created for the client. I want to be able to create all...

I have a query to look at quotation success rate based on the field "quotation accepted" which is a yes no tick box field. I have a sum query where I use the "quotation accepted" field twice in the same query. One is set to "group by" and the second is set to "count". This query works fine...