Search results

Are you wanting certification or just the knowledge to work with databases? Can they be an online course or are you wanting an in the classroom lesson? If you're happy to do them in your own time at your own pace you could take a spy at the following...

Happy to help :)

What is your Filter? Unique Value isn't necessary, I didn't realise you were after multiple value. For Example: You can use a WHERE clause that gets all Customers called Fred. Say you had a table of Customers with States and you wanted all Customers from New York. WHERE State = 'NY'

Hi Greg, I'll find some time to put something together. In the meantime do you have any of the code you tried? It would be handy to see your thought process and can help with the learning process. Did you get any functionality working? Sometimes it's good practice to try writing it all out...

You don't need to supply all the arguments, I just added it for reference. http://msdn.microsoft.com/en-us/library/office/aa141526.aspx DoCmd.OpenReport "CustomerCreditTransactionsReport", acViewNormal, "Customer Credit Transactions Filter" You could change this to use a WHERE condition...

You could link the Query Parameter to the control on the Form. Add a textbox to the Form called "txtSeq_number". Then in the Query add the Criteria of: FORMS!frmName!txtSeq_number Now when you choose a "Seq_number" it will use that in the Query, export it and be the correct name.

DoCmd.OpenReport "rptNAME" Run export cmd below. DoCmd.Close acReport, "rptNAME" - - expression.OpenReport(ReportName, View, FilterName, WhereCondition, WindowMode, OpenArgs)

You may need to change the Filter: expression.OpenReport(ReportName, View, FilterName, WhereCondition, WindowMode, OpenArgs) Tip: http://www.599cd.com/tips/access/open-report-specific-data/

You can refer to a control on a Form and then use it on the Filename when you export Dim strPathAndFile As String strPathAndFile = "C:/.../filename_" & CONTROLNAME &".pdf" DoCmd.OutputTo acOutputReport, "rptNAME", acFormatPDF, strPathAndFile, True

You could use a listbox instead as that isn't editable by default. Does an error message pop up if they try and add something? You could intercept keyboard presses and only allow certain values Private Sub COMBO_KeyDown(KeyCode As Integer, Shift As Integer) KeyCode = 0 End Sub -- Set the...

You could use a combination of the follow tips to achieve your Total: http://www.599cd.com/tips/access/form-footer-total-sum/?key=AlexForum http://www.599cd.com/tips/access/report-sorting-grouping/?key=AlexForum http://www.599cd.com/tips/access/130809-dsum/?key=AlexForum...

How are you exporting the report? Are you using VBA? Are you using a Macro? Are you using the a Ribbon button?

Wrap the DLOOKUP() in an NZ()?

Are they all saved into the same folder? You could use the DIR() function and fill a list box. You could loop through all the files. Use Left(filename, 4) = CustomerNumber (+ padding) And only add it if it matches. Or Open Explorer: VBA Shell "C:\WINDOWS\explorer.exe """ & Foldername & ""...

Hmm that is odd then. You could try a compact and repair, worth a try for any error, just in case! If that doesn't work try a blank db then use the import wizard to transfer the objects across, then try manually again.

Another useful Seminar might be: http://www.599cd.com/site/courselist/seminars/access-calendar/?key=AlexForum There is a "Microsoft Access ActiveX Calendar control." that works in 2007 but not later. You can change "Format =2 dtpTime" You could also add a textbox and set it to NOW() so it has...

In newer versions of Access you can make a textbox show a DateTime picker by formatting as a Date or binding it to a DateTime Field and the little Date Picker control will show up. Or add Private Sub TEXTBOXNAME_GotFocus() DoCmd.RunCommand acCmdShowDatePicker End Sub If you wanting to...

Are you using keyboard shortcuts or the File a Menu? Is the db opened exclusively or could it be read only? Have you tried between multiple dbs or is this in the same one? Can you copy/paste single records? Is the db in a trusted location, or has it been enabled. Did the warning bar appear...

Glad it's working, I've missed the slash myself a number of times! You might want to use Dir() to check it exists and MkDir() if it doesn't.

Do you have a Dim spath As String If you do Debug.Print spath before the Save what gets printed in the console?