Search results

Looks like it is full. Would be nice to know how it was if anyone cares to share their experience afterwards as well as if any of the sessions will be recorded to listen to down the road.

Regarding post #47. The code I provided was portable and relies on the file name passed to it from the calling function/sub. The reason that there was a hard coded file name in the IF statement is because we needed to specifically exclude a table from being attached as we wanted to use a table...

Sorry didn't have a chance to respond sooner, anyway, Gasman is correct, you need to replace BackendDB with the name that you are using for that. Maybe I should have worded it "yourBackendDB" to help indicate that this should be changed. Also, this part of the code (below) isn't necessary, but...

Here is the code for linking. If you need more information or missed providing a code block, let me know. Please try this on a copy of your database in case it needs further adjustment to work for your situation. This code was done some time ago and unfortunately, I did not put source...

I'll post some of the code elements tomorrow when I'm back in the office.

glad the suggestion solved your issue. It's nice when it is a simple fix and doesn't require a lot of code or error trapping to sort out.

You mention header and detail. Is it possible you have a footer section that is blank and taking up space as this could cause the pages to break sooner than expected. Also, what about the margins of your page setup, are they consistent for Header and Footer?

Another option if the FE and BE are going to reside in the same folder then instead of having a specific folder, is to have code which tells the relinker to link to the BE in the same path as the FE. Then it wouldn't matter what folder or computer it was saved to*. Something like this: Call...

Forgot to mention, if you use the pdf printer, then when you actually want to print a hard copy rather than preview, you would need to print to PDF and then print to whatever the default printer is. Of course, if the default printer doesn't have the paper size mentioned of 11x17 , then it will...

Regarding the printer issue, you may be able to do a work around by choosing a specific printer for the report and saving that in design view rather than going with the default printer. If you have Acrobat Pro or another PDF writer as one of your printer options, choose that, otherwise, pick a...

Usually this is caused by the keyboard settings. To temporarily do an F8, or any Function key for that matter, Press the Fn key and keep it held down then press the F8 or whichever function key. Since that can be annoying after awhile, you might consider reversing/inverting how the function...

Regarding the colours, if you are using the standard ones in vba, they could be enters as vbRed for Red and vbNormal for Black Me.Combo0.ForeColor = vbRed

And some years ago, a radio talk show host mentioned (don't know if this is the correct spelling) huperthing, in order to remove man and son from human, person...

Great and easier If they do that. Another alternative if a field is not added--perhaps they can add a unique identifier to the file name of the csv like Export_V1.csv Export_V2.csv Export_V3.csv (V1-Version 1; V2-Version 2; V3-Version 3). Then you can have your code based on those identifier...

Something to consider, depending on the application, the code in post #6 can be run without the need to set focus to the object being copied

This version has a few less lines of code. Put this in the declarations section of the standard module where you will be placing the rest of the code. (After Option Compare Database and Option Explicit but before any Function/Sub. Const DATAOBJECT_BINDING As String =...

This was from an older project and can't remember if it is what you are currently doing or if it does what you would like it to do. This goes in a standard module Public Sub RequeryFormAndKeepCurrentlySelectedRecord(f As Form)...

Not sure if you already thought about highlighting text instead of progress meter? Although the method I use isn't foolproof such as if the code has to be halted before it has a chance to restore the color...what I do is either change the fore color of the (button text/ combobox/textbox) to...

If using vba, for excel export, another option is to use a query or sql statement and then copyfromrecordset. This will paste all the data at once into excel and you can specify the start location - such as B5 rather than A1. Example below tells it to be pasted into row 3 col 1. .Cells(3...

You are welcome. Glad it worked.