Microsoft Access / VBA Forum

The next Access Europe meeting will be on Wednesday 1 Feb 2023 starting at 18:00 (6PM) and finishing at about 19:30 (7.30PM) UK time (UTC) The start time is equivalent to 19:00 (7PM) in Central Europe / CET (UTC+1) and 10AM in Seattle / PDT (UTC-8) For local times, please check https://www.worldtimebuddy.com/ I am very pleased to announce...

I have multiple Access 2003 databases. I do most of the editing in them all the time. I am having a problem of users all over the state being in the database, and won't get off of it. I currently use LDB Viewer. (Which just tells me the computer name that's currently connected). But, is there a way I can write something that will knock everyone...

Good Afternoon, I have been trying to figure this out for days. I have a search form in Access 2007 that is unbound with unbound text boxes. The submit button works great, but I am trying to creat a clear button so that the user can clear out their information at once instead of each individual field. My form name is SearchingForm and the...

I would like to create a drop down list in a form. When month is selected I would like information for that month only to show in form. Would I have to connect to a different table for each month? How would this drop down list be created in form? Usually I have transferred information to an excel spreadsheet then delete entries and start over...

Memo fields in MS Access are similar to the ‘text’ fields in that they allow you to store characters. However, the size of a text field is limited to just 255 characters while a memo field allows as many as 64,000 characters. The actual contents of the memo are stored in separate data pages and the field itself stores pointer to these pages....

Hello, Where does the ODBC Data Source Admin tool store the connection information for User, System or File DSNs? A coworker created/used several ODBC connections on his machine, we backed up most of his files but did not make an image (Ghost), wiped the HD and now I am having to reconstitute his ODBC connections from memory. I would like...

Hi How to delete/ remove all items in a "Value List" ListBox with a button click? I have tried this: For i = 0 To Me.List1.ListCount - 1 Me.List1.RemoveItem (i)

Hello, I have a problem with hyperlink. I have a text box that contains link to the document. I enter the link by clicking on the button "add link". When I add link, the windows browser opens and i can search for exact document. But when I save the path in the Link text box, the link doent work. It is stored in News table and I changed it for...

I need an automated procedure to copy data from an Access table to a SQL Server table. Speed is important. What is the recommended technique? I can export the data from Access, copy it via FTP, then import it into SQL Server. I've tried that, and the speed is acceptable. It is an ugly solution, however, and I expect to find a better one --...

Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all of the Reports, opened by it have been closed, and then makes that (calling) Form visible again. All Forms are shown in Restore mode while Reports are...

I have a textbox in a form into which users enter a string to execute a search. After the user presses Enter, I'd like the focus to go back to the textbox, but the default behavior of the Enter Key moves the focus to the next control. Here's the code: Private Sub txtFind_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode =...

How can I undo the insertion of a new record using VBA? Thanks, Gerry Goldberg

Hi, I have an MS Access 2010 database with a module called bas This module reads the fields on a Microsoft Word document and then the data is loaded to a linked SQL Server 2008 R2 table. I am currently desigining this module so I am the only user using this database. I open the MS Access database, open the code for the module and click on...

I can't seem to get this figured out. I am trying to requery another form after adding new information to a table that a cboList is created from. So, I have a combo box that has Sales personnel, and i have another form that lets me add sales personnel to the table of all the sales team. (Name, number, etc...) But when I open up the main...

I have a report with three columns, accross then down, and two groups. Currently the group headers are only one column wide and appear in the left hand column. How can I make the group header be centered accross all columns? Chuck ....

I need to add milliseconds to this finishtime of race !!! = Format(Now(), "General Date") Start code for race also in milliseconds !!! = Format(Now(), "General Date") I will then subtract it from the start time and get a result in milliseconds RacingTime: Format(-,"hh:nn:ss") Any suggestions on how this can be accomplished?

I have several forms that use list boxes. These list boxes are used to pass information to command line. The operator is not required to select an item from each box. See below ListBox1 - (contains Op dates) ListBox2 - (contains Customer Names) ListBox3 - (Contains File Types) COMMAND BUTTON CODE Private Sub Command239_Click() On...

Hi, Is there an "easy" way to write a full record (all fields) using "INSERT INTO..." into a table which has an AutoNumber field? Normally, to write a full new record I would use: INSERT INTO VALUES (Value1, Value2, ...); If (say) the first field (Value1) is an AutoNumber, what value can you put that will preserve the auto-increment...

Using a macro to output a query to an Excel file. Is there a way to automatically add todays date in the file spec? As: C:\Access Data\ & todays date.xls Chuck ....

Please can anyone help. I am trying to add a button to a form which will pick up an email address, launch outlook, place the address in "Sendto" field and then let me manually type a letter. I have always used the code below but this only works for sending a message then closing outlook having sent an automated message. I need it to keep...

I have searched and searched and cannot seem to find an answer that fits my needs. Hopefully you can help. I have a database that stores names,addresses, etc. I am trying to get it to where I start typing the last name it will 'suggest' names that are already in the table. ex. If the last name is "Johnson", When I start typing "Jo" it will...

I have a table that I am manipulating as a table, not as a form. Is it possible to have a drop down list in a table? I came across this: http://groups.google.com/group/comp.databases.ms-access/browse_thread/thread/509fbf44455ab35d/2e0bced904cccbfa?lnk=gst&q=Drop+down+list+table&rnum=4&hl=en#2e0bced904cccbfa The person answering the...

I can create queries and reports based on info from one table. How do I create one using information from multiple tables. What do I need to make sure the information from one table will be correctly assigned to specific person from another table? Thanks.

1stly sorry for the wrong post in the articles section.. (was by accident) now i have read the thread about Access giving the error of "There isn't enough memory to preform this operation, close unneeded programs and try operation again." I also get this error. The earlier thread about this error wasn't much of a help to me. I use Access 2003...

Hi all !! i have met trouble with referring textbox of subform in VBA i know i can do as: forms!mainform.subform.textbox but i want do it in shorter path. any suggestion about using variable ? Pls help me !! many with thanks !