Search results

Some background on the form and database. It is a split access database with the back-end located on a file server. The database has at most 5 people using it at any given time. The field type is MEMO. If it matters, the back-end database is an .mdb file and the front-end is .accdb I have...

I created a mpeg video of the issue. I uploaded it to my Google Drive. Here is the link. https://drive.google.com/file/d/0B9PKnB_WXZhOZUxIVGRGdFhGN1k/edit?usp=sharing

I have an Access form that is tied to a recordset. When I Set Focus on 1 text box in particular, I move the caret with the keyboard arrows left-right, and the caret moves and flashes on top of the text characters, basically overlaps the character. When I then try to delete or edit the text, it...

Worked like a charm but I noticed that the Activate and GotFocus Events don't fire now when I click on the form to bring it to focus, any suggestions on how to make this happen?

Is it possible to set a property to allow the user to click and drag an open form out of the Microsoft Access 2010 parent window? Specifically to a second monitor.

Has anyone been able to figure this out? I'm having the same issue.

Good Morning All, I am wondering if it is possible to look up the MAC Address of the WIFI access point of which the computer is connected to? I work in an Enterprise environment that has multiple access points and would like to document the AP mac address periodically through MS Access VBA to...

The issue I was having with writing a SQL query was that there wasn't any same fields to connect the data. The names from one table were [Doe, John] format and the other were [John Doe]. I was able to change the names around in the table to make them all read [Doe, John] format and was now able...

I am looking to loop through all of the rows in a listbox. For each row in the listbox, I want to check if the last name in the Labor column is contained in any records in the Labor column of a recordset. If it is contained, add the column value to a variable to eventually be shown in another...

Update: I'm using this Access DB on a touch screen with Windows 7. After installing the DB on the touch screen computer it puts Adobe in touch screen mode which keeps the Adobe Reader control bar visible all the time. This allows the user to use the native zoom in and out buttons. This will work...

I am trying to zoom in a PDF document that opens in a webbrowsercontrol on an access form. I currently am trying to use SendKeys for the zoom in. Here is the code I am trying to use for zoom in. The problem I am having is that when I click cmdzoomin, the PDF rotates clockwise, doesn't zoom...

I have a report that has and 8.5x11 image control on the page. Background of the report: I am using VBA to scan documents in as jpeg files and then using the access report to combine the jpegs and then convert them to 1 pdf document. This process works fine, the issue I am having is when I...

Cronk, this works fine in my particular situation. There is never a chance that a user that changes data will be logged in at 5am. I uploaded it so that other people can use variations of the code to make it work for their DB.

I have a similar setup as you described above. I have a split access database with around 5 front end users that all generally work on first shift 7-3:30am. What I did for this situation is build into my main navigation form code to quit the front-end database at 5am if it was left open by the...

Someone may be able to use this. This code will scan up to 10 documents using a continuous feed scanner and output them to a pdf.

Can you offer up any other suggestions to embed a web page into an MDB form?

I am trying to copy a form from an accdb database to an mdb database. The form copies fine but when I open the form in Design view, the Web Browser Control is not there. When I try to copy the WBC over from the accdb to the mdb, an error message shows that says "The Web Browser Control is not...

This is exactly what I needed. Additionally, I was able to update the date portion by reversing your VBA using TimeSerial along with the DateSerial Function. Thanks for your assistance.

I have a date/time text field on a form with the General Date format and a combo box next to it that has sequencial times as the row source (IE. 12:45 AM, 1:00 AM, 1:15 AM, 1:30 AM, ETC.) When the user chooses a time in the combo box, I want the time portion of the text box to be updated with...

I was able to make it work with the method I used. So far there haven't been any issues. Do you think that I should still create a new column and run the update query like you suggested?