I have an Access 2003 Database in which I would like to run a query to change the default values for several columns within a table to NULL. Is it possible to write a query without VBA to do s...
Hi,
Can someone help me Split a variable. I am trying to split it and place the results in the caption part of a label. Whenever I try this though I get a data type mismatch error. The code I...
Hello Experts!
I have a 3 column combo box based on a table.
Before a user makes a selection, all 3 columns are displayed.
After a user makes a selection, only 1 column is displayed...
Creating a dynamic field called Overall Balance. Looking at one field for a "C" and another for the month. If there is a "C" and the month is = x, then put the value of the current balance o...
Hi everyone,
I would like to create a comment box in my form that can be edited before I run the invoice. Here is what I have done so far. Created the following table.
Record # Date Emp...
Using Access 2K, Windows 2K - I have a database that runs a Do...Loop statement to modify some fields in a table. The code runs fine on my local disk, but bombs out every time when I try to c...
I built an Access DB for work in 2003 and we have just installed Access 2007. The DB is a FE\BE app and we used to be able to go to Linked Table Manager, select all tables, and browse for the ...
Hello,
I have a database .mdb which has got corrupted (Error 3197). I can't open it. I have tried and searched any solution, but apparently there is no one.
Can somebody help me, please?
...
I'm sure someone has the perfect answer for this. what is the trick to inserting text into a table via sql/vba that includes apostrophe's? (Or other characters that will break it for that matt...
If the limit to columns in MS Access is 255 accross and I am trying to import a DB that has 1800 columns ? Is there a way to get that to come over in Access or is the only way to do that found...
Alright Access experts!
There are a lot of "export to excel" posts on EE and the web in general. There are even a couple that were posted by myself over a year ago when I was trying to do s...
Hi,
I have two tables in MS Access 2003:
> tbl_project; and
> tbl_requirement.
tbl_project has fields "project_id" and "project_name"
tbl_requirement has fields "req_id", "project_i...
access VBA
Hi.
I called module2 in the same data base inside another function which executing as Event, but Error occured
why ?!!
Option Compare Database
Option Explicit
Privat...
I've got a small organization that requires a storeoom management system; penciles, calendars, toner, paper and such. They'd like a basic chargeback system; allowing employees to look into th...
Hi,
How can I multiple select items in a ListBox without knowing the Index?
Any workaround?
I'm using MS Access 2002.
I have two subforms that I am trying to synchronize and it's not happening. I am wondering if you could help please.
Subform 1 is called frmCampaignsSub (continuous form)
Subform 2 is call...
I have an Access application that I need to be able to run on a users PC that has not got access loaded, i.e It needs to be a platform independant executable file.
Obviously this means it ...
Hi Experts I have a select query that uses text boxes from a form as its criteria. The SQL looks as follows:
SELECT GLExtract.BusinessGroup, GLcodes.RCode, GLExtract.DataItem, GLExtract.Month...
I need help with code sample to get the max(system_creation_date) where the acct_nbr in Tbale 1 = the acc_nbr in table 2. That data needs to be inserted into another table. Asingle row should ...
hello i am having a problem with one machine on my server 2003 domain. the user is having trouble opening their copy of the access xp "2002" database they have read only permissions to the da...
Hey there, I'll try to explain this to the best of my ability.
I have one table with customer contact information. I would like to have an Access Form that will query the data from table cu...
I am creating a form that will allow users to view a summary of trading activity by month. I created a query which takes the user input (year, sector, min trade size) and returns the sums gro...
I have MS Access as the front end with tables from an SQL database linked into the access file and these act as datasource for the various queries which are displayed on the click of buttons o...
I have a workbook that's generated form a website and needs to be imported into Access 2000. However the workbook is created, Access will not import it with a message something like "incorrec...
Is there a way using the Trim function in Access to remove a space. In the following address field which is coming from a packaged field. It looks like this:
Manhas...
