Search results

Can you please post the entire code; you have variables not declared in the piece you posted (ShowPDF, LNameLookUp)? Here is an updated version of your code, see if it makes any difference: Dim DateForQuote As String Dim DestPath As String Dim CustomersID As Long 'Integer safer to use long in...

In the combo's AfterUpdate event after you set the Days to 30 on the next line call its AfterUpdate sub: Me.Days=30 Call Days_AfterUpdate() Cheers,

Not in there but in the report's record source, replace what you have with this and give it a try: SELECT Conseller01.IDD, image.Path, IIf(IsNull([Path]),"N\A",Right([Path],4)) AS FileType FROM Conseller01 INNER JOIN [image] ON Conseller01.IDD = image.IDD WHERE...

You can read the text file (CSV) line by line, many examples on the web, here is one: https://www.automateexcel.com/vba/read-text-file-line-by-line/ Here is a link to my Google search...

Can you please try this version? I have set all margins to 0 and set the printer to Microsoft Save As PDF (in the report). Cheers,

Here is a small sample with how I used to do the same thing (almost, as the Access tables were actually local front-end tables instead of linked Access tables, the file was intended to be a single-user portable app to enter contact info in the field and then synchronize with the SQL server when...

Please have a look at my free sample here: http://forestbyte.com/ms-access-utilities/fba-outlook-email-parser-importer/ Cheers,

Why not make the insert a pass-through query instead? Cheers,

After this lengthy discussion I just wanted to point to some code that does what you originally wanted among other uses: http://forestbyte.com/ms-access-utilities/fba-fe-to-be-table-push/ Cheers,

Hi Dom, Looks like the actual form name is DeviceDetails not frmDeviceDetails as you mention your your posts here so lets keep that in mind. There are few issues with your setup. And you are not showing us the code you have in the open event of the DeviceDetails that makes use the OpenArgs...

The problem is the form now a has recordsource returning only one record, so MCCDOM's old code to open the form at a specific record is failing (haven't seen it yet but probably using Docmd.FIndRecord or recordset findfirst+ bookmark or similar methods), nothing to do with bound controls. Cheers,

My point exactly that I was trying to make in post 22 and 24.... Please post the code you have in the frmStaffDetails form, it should be changed to populate the combo on the frmDeviceDetails form and then call it's AfterUpdate event (you will need to change it from Private to Public). Cheers,

Looks like you can overwrite the user's setting with the admin DefaultMountPoint setting: https://workspaceupdates.googleblog.com/2018/02/new-drive-file-stream-settings-for-your.html https://support.google.com/a/answer/7644837?hl=en

Strange, I had no problems with it, but here it is, let me know if it works. Cheers,

Have you had a chance to download and look at my utility? You need to import all objects (make sure you turn the View system objects on as there are a few custom system tables prefixed with "usys"). It basically stores the "access" rules in a shared system table to you can add\edit\remove rules...

Have a look at my free utility here: http://forestbyte.com/ms-access-utilities/fba-custom-access-levels/ Cheers,

You're welcome, hopefully it helped you learn a few things about VBA syntax. Good luck with your project! Cheers,

Please review the updated file. Note that I copied the code into the form module so you could refere to the textbox using the Me.txtbox. I also modified the public function you have in the standard module. You can switch between them in the Open event of the form (removed the macro and used VBA...

Your design does not follow relational database design (not properly normalized), soon you might need a fifth and sixth contact and you will have to change all the objects involved. But back to your question, what is the current tab order? Txt1,cmb1,txt1,cmb1,....? Try to use the AfterUpdate of...

On my website I have a free utility that allows you to design your pivot tables inside your Access application and programmatically create\update them in external Excel files. Make sure you import all the objects from the sample...