Search results

Hi Patrick, Couple of ways to handle this. 1) If the report you want to save is only used for this action, set the report filter so [ID]= Forms.[FCP Requests].[ID] and the FIlter On Load to TRUE. If the report is used elsewhere, create a copy just for this action. 2) Use a query to return just...

Hello, DoCmd.SendObject is one method. The correct syntax is: DoCmd.SendObject acSendReport,ReportName,Format,To,CC,BCC,Subject,Message Text,Edit so in your case probably; DoCmd.SendObject acSendReport, repName, acFormatPDF,Addresses to send to, CC?,BCC?, "Listino Tetris Consolidation export...

You have the End IF's in the wrong places. The last 2 are not needed and you need another End IF before SetClient.SetFocus. I have colour coded the If groups below and you will see they are out of sync. Private Sub TOEnterByAll_Click() On Error GoTo TOEnterByAllBtn_Click_Err Dim...

You can change these'globally', but this change will apply to all databases you open. To do this you provide the name of a report or form as the template. Either use an existing form/report in the current DB or create an 'optimum' form/report with all the controls with all the correct settings...

Hi Rusty, Personally i would say not. I generally supply FirstNames and Surname fields. For display purposes concatenate them, EG Surname, Firstnames. Users have the option to sort on either name. I have gone with a single field a couple of times, but in those instances i provide a form for...

Could you post the SQL of that query please?

If it is a bound form, just add the code; docmd.GoToRecord,,acNewRec If it is an unbound form, just set the controls to blank (or a default value) and set focus on the first control

Hi Juddy Simplest way i can think of would be to use error trapping and ignore the "Query must have at least one destination field" error. To do this; Add error trapping and use a message box to display the err.number Run the macro when you know the CSV file is empty, so you get the error...

The link should refresh automatically each time the database is opened. You can use the TableDef.RefreshLink Method to update via VBA. HOWEVER, if all the users have MS access on their PC's, it makes more sense (to me) to just use MS Access. If the data is manually keyed in Excel, then create a...

Hi Dan, I would look at using your code in the AfterUpdate event for Txtboxshipactual. That way when ever that date changes the other calculations are carried out.

Hi Dan, Can you confirm please, is Access the data source for the Excel file OR are you using the Excel file as a data source for the Access table? What do you need to happen when it "auto recheck the data"? Are you checking to ensure it is uptodate?

Hi field name Outside 2 has a space in it. You need to surround it in square brackets, so [Outside 2]. Or is the field name actually Outside_2?

If i understand your post correctly, you want to flag the chronologically first entry of ID as First_Delivery and subsequent entries of the same ID as Update_Delivery? if so create the new field in the table first. Now create an append query. Use the Dmin() function to check if the date is the...

Hi, Couple of possibilities spring to mind. 1, is QuoteNumber text or number (if number you do not need the ' ' ) 2, You have a space after the last quote mark & "' " should be & "'"

Hi Galaxiom, Wow, good link (still on the Yellowglen?). Would that method still cause the headings problem in a report though?

You want to look up Crosstab queries. This will give you the recordsource for a report. However the variable nature of the number of headings will cause problems (each time you run the report, unless you have the same number of headings as when you first run it, you get errors and parameter...

The way to tidy this up is to use the left property of the visible boxes. A little more code (and a lot of working out first). If all 5 field controls (lets just call them fields!) are the same width it is simply a case of noting the left property of each:eek:. If the fields are differing widths...

The basic code would require the use of a loop and Dlookup()'s to identify which FIELDS (columns are used in spreadsheets!) to display. If the field is to be hidden use the Me.ControlName/FieldName.Visible = False. Where to place the code is dependent on when the diplayed fields could change...

Make use of DateSerial() & Year() functions. so something like;Between DateSerial(Year(Date()),12,1) And DateSerial(Year(Date())+1,5,1)

Ditto the 2 above and also consider queries, forms & reports. You would have to keep changing the designs to account for the new fields. if mods can be applied to multiple machines Table1: Machines Table 2: Modifications Table3: MachineMods OR if mods are purely machine spedific Table1...