So I can use this:
DoCmd.GoToRecord , , acNewRec
To make a form go to a new record. But I can't get it to work in this situation...I have a page (tab) that contains an unbound form ...
Hi Everyone-
I am fairly new to developing with VBA and I am stuck on a problem. I have an Access database that current runs a screen scraping process to get data. The screens are being retir...
Hi all, I have a table that has among other fields the following two fields:
1.) TimeCreated - this is a date/time field - sample data "12/4/2006 9:10:43 AM"
2.) ListID - this is a uni...
Hi,
Sorry if this is long winded, but im trying to give you as much detail as possible, so that you understand the problem better.
I have designed a database in access to use with my VB....
Does anyone have some kind of example and reference that shows how to programmatically create a system DSN to a SQL Server from with-in Access using VBA?
I don't want to use a custom C+ or ...
I have added the calendar control to the Switchboard in the attached database. I thought it would keep the correct date as days passed, but it doesn't change. What do I need to do to activat...
Hi experts ,
I have a VBA procedure, where I have manged to calculate the data i need, and in the immidiate windows I am able get the output that would need by adding debug.print in a loo...
I'm wondering if anyone knows how I can disable the mouse scroll to prevent users from scrolling into another record in a form, but still allow scrolling within large text boxes or combo boxes...
Where does MS Access get the index information from for linked tables? I looked through all of the hidden and system objects and none of them seems to have index information.
The reason I ...
I put the routine that I have a question about in the code snippet window. I want to update two fields base donthe paramters passed to this routine. The first is 'StatusID' (Long) which is r...
How do I disable the design view option from showing up in access when I mouse right click?
I will like to include code that I can run on startup to disable all users from seeing the design...
I have an unbound form that I use to select records. The date field(s) are comboboxes and you can select a DateRange and it calculates which records to return
I've got these working so far...
Hi, I don't understand what is wrong in there,
If Not IsNull(txtID.Value) Then
Const conNumButtons = 8
Dim con As Object
Dim rs As Object
Dim stSql As St...
I have a school project in which we're making an Access 2007 database to maintain user accounts in a retail atmosphere. I've been trying to figure out a way to round the package out by automa...
I import an Excel file directly into my Access 2007 database. Some of the column headers in the file use a ".", that is a period, and so do not import into Access. I have written a macro in ...
I have a form in Access 2003 that's built on a test table with 10 records. If i create a new(blank) record using the navigation buttons, then hit ESC, and then click the "previous record" na...
Would you guys be able to point me in the right direction here?
I have a database that I'm in need of adding some security on. Most notable, all the tables associated with it.
I know I ...
Hi. I am trying to write an access report based on a query that will prompt the user for select criteria - area, and "priority >" a number they enter. My question is how do I set this up to al...
So I'm pretty well versed with database concepts, relationships, etc. I've done many-to-many relationships (with a junction table) before, but never with an accompanying form. I need some gu...
Good Morning,
Can someone tell me how I would get a multi line text box in my form. Also, using VBA how would I add comments to it when my program is running?
Thanks
I have a make table query that is based on two tables one of which has a yes/no column it it. This column is in my new table as well. When i run the query the yes/no column loses it's DisplayC...
Hi,
Wondering if it is possible, and easy(!!), to link to, or import data from Active Directory into MS Access 2007?
I've google'd this and have found some references to VBA, but ideally...
the following code does not work
i have a table named ProjectTable with a field named Project Name and at least 1 record in that field that stats with the letter T
any reason why this code...
I have an Access database (import from Excel), in which I have several columns such as: University, General Information, Department/School, Program, Links, Deadline... (total 11 columns)
Now ...
The code below is executed in Microsoft Access to open an Excel file, find any blank rows (where the formula in the cell returns an empty string) and delete them. The code works as expected t...
