Search results

Morning - I hope you are all well. Not getting as much of a chance to develop in Access any more and a bit rusty. I use a browse function to let us capture a file name and location and save it into a table. The name is made up of two parts, the job number, and the file name. Any spaces...

Hiya. I run duplicate check on a form to make sure the file name doesn't match one that's previously been entered. Currently I have: If Me.NewRecord Then If Not IsNull(DLookup("File", "tblFileProcessing", "[File]=""" _ & Me![File] & """" & " and...

Morning. I'm looking for an Access developer in the Lothians area of Scotland to take over and manage 4 databases that I' have developed and managed over the past five years. Unfortunately a change in work committments means I am no longer in a position maintain these database for external...

Just wondered if anyone had any suggestions. I have a subform with a drop down list of requirements. Every client needs to have a response against all the requirement options but I don't want to hard code the requirements into a table and form as the options will change or be added to. So...

I posted a bit about this earlier in the week but didn't get any responses. I don't think my explanation of the problem was very good! Here's another go which I hope might be clearer: I have a database that records samples received into a lab. This includes the sample type and the...

Background: I have a form that logs multiple rows of data for each case: Material Option, Material Type and Area for reporting purposes I use this code to loop through the records and create a string so that the information can be output as a mail merge bookmark to a Word document template...

I'm trying to add in an order when I create a dynamic query. This is the code I currently use which creates the dynamic query: Set QD = db.CreateQueryDef("qryFrmSelectAreas_Dynamic", _ "Select * from tblLookupAreas") I'm trying to add in a sort by changing this...

I'm using the current code in a function. It was written in Access 2000 and I wondered if there was anyway to update it so it can run in Access 2010 without having to specify the old reference. Public Function ApplianceList(WOProp As Integer) As String Dim strSQL1 As String Dim Answer As...

I've been approached by someone who has a backend datafile that appears to be corrupt. They tried to company and repair it and when you try and open it it's giving you the message: "The Microsoft Jet Database engine stopped the process because you and another user are attempting to change the...

I'll try and make this as concise as possible! I have a record with a subform. Within the subform there are, say, 3 individual records. Each record has it's own text field and number required. I want to print labels to a sheet that loops through each record and creates the number of labels...

Is there any way to globally switch off this property in Access 2010? At the moment I'm having to reset the property for each and every grouping level and it's driving me mad. Even setting the default to No Color would be enough.

Hiya I've been developing for a while but I'm always looking to improve my skills. I have just upgraded to 2010 which I'm liking (jumped from 2003). Can anyone recommend some good Access Developer books that might help me. I'm a learner by doing rather than by reading normally but feel there...

I've been very successfully using the code to create a snapshot of a report and then converting it to pdf to send as an email attachment. I've just upgraded to Office 2010 and realised that this didn't work any more and have re-written the code to use the facility to send the report as a pdf...

I've got a form with subform. There's a button on the main form that lets the user view and select products to be added to the subform. They do this on a product by product basis. After they have double clicked the product they want (which then drops it into the subform) I want to move to a...

I have a search form that lets the user search for properties by postcode, address line 1 and either the last service date or the next service date. This is the SQL that I’m using to filter: If Not IsNull(Me.txtPlannedDateFrom) And Not IsNul (Me.txtPlannedDateTo) Then where =...

I have a two stage event on a report. If the user hasn't printed the report by the time they click close it prompts them using the following: Private Sub Report_Close() Dim stdResponse As Integer Dim Cancel As Integer If Flag = 2 Then stdResponse = (MsgBox("You have not...

I have a course set up with a start and end date. The course runs one day a week and I specify which day in a drop down list. I need to print a class list for each class day from the first date to the last date. Any ideas how best to do that? Would I need to create a temporary table of all...

I'm trying to auto fill a field in a main form based on a click selection made on a pop-up. I'm trying to make the pop-up accessible to a couple of different main forms and want to dynamically name the field I want the data to be dropped in to. I tried: Dim stDocName As String Dim...

Can anybody tell me the maximum size that a form should be to fit fully in a 15" monitor with a 1028 x 800 screen resolution? Don't want to set the forms to pop-up mode as that gives me other problems but this is the smallest screen size that the database will be viewed on. Thanks.

I have a system that logs tradesman bookings on half hour slots on any given day. I'm trying to use a dynamic crosstab report so that the users can view the diary at any given time and see who is booked out when and what spaces are available for the next two weeks. This report (which I've used...