Search results

Hey guys, I have a form that allows a user to search for a client. There's currently 4 different ways the user can search, by account number, client name, postcode and creditor. Now, the clients name is stored as a full name, there's no seperate fields for first and last name. Typically a...

Hey guys, I'm having an issue with one of my queries. Basically I'm trying to create a performance report that uses the following fields: Filterer (Text) Advisor (Text) LeadSource (Text) Now, the process is as follows: When a client phones in, the filterer enters them onto our system...

Hey guys, I've just created a button that uses the RunApp macro to open up a mail merge for our database. Is it possbile through some VBA code to jump to an exact record in the mail merge? So, for example, if I'm on AccountNumber 29 and click the Mail Merge button, the mail merge will open up...

Hey guys, I seem to have fallen victim to the evils of lookup fields...I'm trying to create a query that I can use in a mail merge, but my current table setup is giving me a lot of problems. Basically I have two tables, one called Creditors and one called CreditorInfo. Creditor info stores all...

Hey guys, I'm having problems trying to make a required field pop up a message when it's left blank. It's for a subform and I don't think the code I'm using as the destination is right. Here's what I have at the moment: Private Sub Form_BeforeUpdate(Cancel As Integer) If...

Hey all, I'm having an issue merging two queries of mine. Basically one shows a clients income and the other shows a clients expenditure. The tables in both queries consist of an Account Number, a Type and the AmountPaid. Usually there are more entries in the Expenditure query, but when I join...

Hey, This is probably a really simple question but I can't seem to find the answer anywhere! I have a query that shows when a client needs to be distributed (DistribStart). I want to display all records due to be distributed this month and also next month. How do I do this? Help would be...

Hey guys, I currently have a Note box on one of my subforms that locks after something has been entered and the user has clicked out of the box. Now, this worked at first, but one user has been trying to copy and paste information from some of the other tabs and when she leaves the current tab...

Hey all, I'm having an issue with a query I'm trying to create. The purpose of the query is to ultimately create a 'performance' report so management can see how well a particular employee is doing. We have two types of employee's, filterers and advisors. A filterer finds leads for the advisor...

Hey all, I'm having issues with a Total's query I'm using in my database. The query returns a count and then a sum of the amount of leads we get from a broker. Now, I want to find out how many leads have been given to us between two dates (which are entered by the user). The current Total query...