Search results

Hi all Again, I've searched for ages but I think there's a particular element of what I'm trying to do that I can't find the answer to. The code below basically loops through the table (tblMaster) and creates a new table for each Agency. All works fine. What I've now been asked to do is add...

Hi all After a thorough search I can't find a solution to my issue. Any help gratefully received. I have a table (tblMaster). In the table is a field called Agency. The table is 200,000+ records and there are around 35 Agencies. The table grows monthly, with potentially new Agencies added...

Hi all Apologies for the new thread. I have been through umpteen threads that kind of address my issue but nothing that really outlines how I should proceed. Anyway..... We have an Access 2007 database at work. At present it works fine, standard front end-back end set up with BE on the...

Hi all I've searched to try and find the answer this this but with no luck - probably not searching for the right keywords. Anyway, hope someone can help. I built a pretty standard Access 2007 database at work, front end back end set up, all been working fine. Been on a weeks holiday, come...

Hi all Apologies for the new thread, had a long search and solved most of my problems but one remains! I'm working on a database that identifies duplicate invoice numbers. The one remaining issue I have is that the spec requests the ability for the database to find potential duplicates where...

Hi folks Apologies for a new thread but I've got a real head-scratcher that I hope someone can help with. Couldn't find anything to solve this using the search. It's basically trying to find duplicates in a list of invoices, but with an added complication. We are interested in 3 fields -...

Hi I've had a search through but to no avail. I'm trying to import data from an Access query into a blank spreadsheet (Data-Import External Data etc), but it's only giving me a list of the tables in the database and not listing any of the queries. I've never had any problem with this before -...

Afternoon all I hope someone can help with this problem. I use the following code (taken from here obviously - thanks Rural Guy) to DateAdd taking into account working days and holidays - all works perfectly. Public Function PlusWorkdays(dteStart As Date, intNumDays As Long) As Date...

Hi Again, I've had a search, but can't find anything to solve my problem - so sorry if I've missed it. Basically, when I compact and repair the database I'm developing at the moment, I get the error message - Table 'TempMSysAccessObjects' already exists. There is no table of that name (or...

Hi. Again, apologies for starting a new thread but I can't find a solution via the search. I have a comments box on a form that users need to be able to update but not delete anything already entered in it. In other words, they can add new comments to a record but not delete old comments, in...

Hi. Apologies for starting a new thread but I can't find anything in the forums that cover this. I think I just can't figure out what to search for! I have a text box on a form called SAPRequisitionNo. Basically, I want to make entry into this text box compulsory if there is an entry in...

Hello Another problem that I hope someone can suggest a solution for! Basically, there are a number of dates entered by the user on a form that need to be within certain parameters based on another date in the form. In the first example the date DateRequestedFromExrTarget needs to be...

Hi I hope someone can shed some light on this. I'm sure the answer is right in front of me. I have 2 IIf statements in unbound text boxes on a form. One works and the other produces a #Name? error. The 2 statements are =IIf([1stProofActual] Is Not...

Hi I wonder if anyone can help me with a weird problem I'm getting at the moment. I use a module to calculate working days in various databases I've set up - has always worked fine. However, I do my job from 2 separate sites and last week set up a few unbound text boxes in a form as users...

Hi I've had a search through the forum but can't find anything to solve my issue. Hope someone can help with this one. I want to filter a query (ultimately a report) based on date parameters entered by the user (start date & end date) on a form. I've done this plenty of times before with no...

Hi Hope someone can help with this. Had a search through the forums but nothing quite the same (although I'm guessing it's a simple one to solve.) I need to calculate a figure based on 2 criteria. The permutations are as follows If condition A is less than 20 and condition B is No then...

Hello everyone I'm fairly new to Access and hope someone can help with this problem. It strikes me as something incredibly simple to solve but my brain seems unable to provide a solution today. I've had a good look through the forums but can't find the answer. I have a form to enter details...

Hope someone can help with this. I'm sure it's dead simple but it's driving me insane! The scenario is a number of departments who are processing something (sales for example). So, for October Dept 1 - 20 (Sales) Dept 2 - 10 Dept 3 - 2 Dept 4 - 7 Now I want to count the number of sales...