I'm working on an Access project where I need the VBA API for the "Folder Dialog." I'm not sure what the recognized name of the dialog form is, but it's the form that allows the user to selec...
Right now I have a database that contains liked SQL tables. If I want to analyze data "offline", I simply just cannot copy the database as another .mdb file because the tables are copied as l...
I have a form in Access that sets up a training event. The training coordinator selects the time and location and the attendees from a listbox. I have added a button on the form that is intend...
I have a motorola i335 that Ive been trying to get unlocked. I asked motorola and they say talk to my provider. I call my current provider and they say talk to the provider the phone from. ...
I have a form with a unbound CBO box that is used to display a records query. When the user clicks one of the displayed records, the form moves to the associated record. I also have an "EZ F...
Hey Experts,
I have a Quick and EASY question.
How can I use DoCmd.GoToRecord command?
more information...
I have a form with is linked to a table with unique ID.
I have a inputbox...
I need to create a virtual Recordset in code and populate it with data. This code will not be based on an existing table, so I would have to create it's field names as well.
Can you please ...
Hello EE,
I need to standardize mailing addresses. I have a table, tblAddressChanges, with two fields [Part], and [CleanedPart]. The intent is to have a function that will replace the Par...
I modified some code provided by ChuckWood to open a URL using VBA from Access. If I click on this URL, IE opens and a Open/Save/Cancel dialog displays. I can press the tab key 3 times to set ...
I need to remove all non alpha numeric characters form a string. e.g characters like !@#$%^&*()_- etc. I only want to retain the characters a-z & 0-9
I have included the function that I hav...
I'm not very knowledgeable of VB, but I've learned a lot from searching these forums. However, I can't find a solution for this one, so here goes:
We are reformatting a huge number of Word...
I am trying to streamline a reporting tool that I developed previously. The report form allows the user to enter a date range and multi-select filter criteria from 5 list boxes. Then they choo...
I have some code that is now successfully(thanks to Helen in EE) opening a database that is password protected. The problem is that it is also asking for my workgroup login and password, and ...
Hi,
I'm trying to get the "top 3" in a dataset.
The query that I've been using is:
SELECT TOP 3 *
FROM data
ORDER BY count DESC;
for some reason its giving more than 3! The data set...
Ok, so I am exporting tables and associated data to my destination access database defined by qaPath in the code below that resides in a module of my source db. Then, when I open my destinati...
I am trying to update 'Amount' values in my 'Positions' table to be the 'Amount' values in my 'TempTable', but only when the field 'SecType' in my Positions table is 'ca'
Can someone explai...
I have a table "1_images" with columns (show in pdf)
I already have a query based on form that will give me the records listed one by one.
What I want is like I show in pdf where it further ...
I really wrecked this code. I need some help, please!!
i = user entered date
I want it to return the values specified after the "Then".
If [User Entered Date] is not a weekend and is...
I have data by hours for 5 years worth of data. I need to adjust them for daylight savings time by adding a new column called peak and off peak. Peak will be hours 8-23 EST in the winter an...
Hi,
I have an Access database used to manage invoices. I need to archive all records older than 6 months. The user has requested that these records be visible in a separate Access database,...
I have an access database in Access 2003 version 11 with SP3. Everytime in modify a form or report the database gives me an out of memory message and the form or report becomes useless. I ne...
We have an MS Access Database with our contacts in it. We want the ability to send an email to a list of recipients using an outlook template from within Access.
Hi Experts!
My project will ask the user for year and month, then it will show the last 4 months from the month and year chosen. So it will display a 5-month report. I have been able to for...
Hello EE,
I am using this EE constructed code to append filenames to a table, and then to append the Excel Sheets to another table. The error occurs in the GetTabs() module if there is a s...
I've never quite understood what it is I'm really asking for with DBEngine(0)(0).TableDefs, and how and why it differs from CurrentDb.TableDefs. I just know that it needs to be used sometimes...
