Passing a form to subroutine in Access 2003 (VBA)
I have a function that recieves references to 2 forms and 2 controls. The sub looks like this Public Sub Not_In_List_Starting_Handler(vNewData as string,Not_in_list_form As Form, List_control As Control, Lookup_Form As Form, Lookup_Control As Control) when I try to call it from the form I get all types of errors – data mismacth, byval required, etc.. [...]
Answer Question
| March 31, 2012 3:56 AM
Access 2003, Acess 2003 forms, VBA, Visual Basic
I have a function that recieves references to 2 forms and 2 controls. The sub looks like this Public Sub Not_In_List_Starting_Handler(vNewData as string,Not_in_list_form As Form, List_control As Control, Lookup_Form As Form, Lookup_Control As Control) when I try to call it from the form I get all types of errors – data mismacth, byval required, etc.. [...]
Answer Question
| March 31, 2012 3:56 AM
Access 2003, Acess 2003 forms, VBA, Visual Basic
User Accounts in Access 2003
I set up successfully user accounts and passwords in MS Access 2003 on my computer. when I transfer the file to another computer the login form no longer comes.
Answer Question
| March 31, 2011 6:13 PM
Access 2003, Access 2003 forms, Access 2003 Security, User Login Data
I set up successfully user accounts and passwords in MS Access 2003 on my computer. when I transfer the file to another computer the login form no longer comes.
Answer Question
| March 31, 2011 6:13 PM
Access 2003, Access 2003 forms, Access 2003 Security, User Login Data
Access 2003 IIF Function?
I have a form and a subform relating to vehicles. The subform has starting mileage, ending mileage and the purpose of the vehicle’s use, one of which is oil change. I would like a text box on the main form to show the next oil change mileage which should be 4500 miles from the ending [...]
Answer Question
| March 11, 2011 2:45 PM
Access 2003, Access 2003 forms, Form, IIF, Subform
I have a form and a subform relating to vehicles. The subform has starting mileage, ending mileage and the purpose of the vehicle’s use, one of which is oil change. I would like a text box on the main form to show the next oil change mileage which should be 4500 miles from the ending [...]
Answer Question
| March 11, 2011 2:45 PM
Access 2003, Access 2003 forms, Form, IIF, Subform
Access 2003 report printing
We’ve been using Access 2003 for a while and are now changing over to 2007. At the same time, I am creating a new report to replace a report we’ve used in a database successfully for several years. I open the new report, and it looks perfect on screen, then I print it using the [...]
Answer Question
| April 12, 2011 6:15 PM
Access, Access 2003, Access 2007, Access 2007 printing, Access Database
We’ve been using Access 2003 for a while and are now changing over to 2007. At the same time, I am creating a new report to replace a report we’ve used in a database successfully for several years. I open the new report, and it looks perfect on screen, then I print it using the [...]
Answer Question
| April 12, 2011 6:15 PM
Access, Access 2003, Access 2007, Access 2007 printing, Access Database
How to count data in Access 2003 stored database
hello to all, will u please help me on how to count data in stored data in database, I am using ms access and vb6. Thank you
Answer Question
| February 17, 2011 12:21 PM
Access 2003, Access Database, VB 6.0, Visual Basic, Visual Basic 6.0
hello to all, will u please help me on how to count data in stored data in database, I am using ms access and vb6. Thank you
Answer Question
| February 17, 2011 12:21 PM
Access 2003, Access Database, VB 6.0, Visual Basic, Visual Basic 6.0
How to concat SQL Server 2005 data with line feed
I am attempting to update a column in SQL Server 2005 by concatenating data from two other columns and include a line feed between the two and have the second line begin with a /. The data will be viewed through an MS Access 2003 database with a linked table using an ODBC connection. The [...]
Answer Question
| February 2, 2011 10:46 PM
Access 2003, Concatenate, Line Feed, SQL 2005, SQL Server 2005, T-SQL
I am attempting to update a column in SQL Server 2005 by concatenating data from two other columns and include a line feed between the two and have the second line begin with a /. The data will be viewed through an MS Access 2003 database with a linked table using an ODBC connection. The [...]
Answer Question
| February 2, 2011 10:46 PM
Access 2003, Concatenate, Line Feed, SQL 2005, SQL Server 2005, T-SQL
How do you change user password for a separate Access database than you are working in?
I’ve built a database (Production) with user level security on it. I also have built a smaller database (Login) so I don’t have to use Access’ login. I’m trying to figure out if there is a way to change the user password in the Production database FROM the Login database. I’ve been working with the following [...]
Answer Question
| January 28, 2011 4:00 PM
Access 2003, Access 2003 Security, Access Database, VBA
I’ve built a database (Production) with user level security on it. I also have built a smaller database (Login) so I don’t have to use Access’ login. I’m trying to figure out if there is a way to change the user password in the Production database FROM the Login database. I’ve been working with the following [...]
Answer Question
| January 28, 2011 4:00 PM
Access 2003, Access 2003 Security, Access Database, VBA
Cumulative totals in Access 2003
I need to be able to calculate cumulative totals on groups of data in a query. Specifically I have a list of repair order numbers with associated part numbers required, dates the order was placed and the amount of the part needed for the repair. I need to be able to calculate a running cumulative [...]
Answer Question
| July 12, 2011 1:01 PM
Access 2003, Access 2003 forms, Access Database, Access query
I need to be able to calculate cumulative totals on groups of data in a query. Specifically I have a list of repair order numbers with associated part numbers required, dates the order was placed and the amount of the part needed for the repair. I need to be able to calculate a running cumulative [...]
Answer Question
| July 12, 2011 1:01 PM
Access 2003, Access 2003 forms, Access Database, Access query
Converting from Access 2003 to Access 2007
hi, everyone i have 3 desktop with Access: one have Access 2003 two of them have Acess 2007 so i divide my Access database in two parts on of them have tables an other a form queries, etc. My problem is, is possible link tables for these three desktop’s. because of that diference i convert [...]
Answer Question
| January 17, 2011 5:05 PM
Access, Access 2003, Access 2007, Access Database
hi, everyone i have 3 desktop with Access: one have Access 2003 two of them have Acess 2007 so i divide my Access database in two parts on of them have tables an other a form queries, etc. My problem is, is possible link tables for these three desktop’s. because of that diference i convert [...]
Answer Question
| January 17, 2011 5:05 PM
Access, Access 2003, Access 2007, Access Database
Create “if then” formula in Access 2003
Hello, I’m new with access. I have a table with article numbers in one column. and intro and outro dates in 6 columns. the intro and outro dates come from 3 tables, so that’s why the 6 columns (2 columns per table) However, I would like to combine the six columns into 2 columns, one [...]
Answer Question
| August 17, 2011 8:41 AM
Access 2003, Access 2003 date query, Access 2003 forms, Access forms
Hello, I’m new with access. I have a table with article numbers in one column. and intro and outro dates in 6 columns. the intro and outro dates come from 3 tables, so that’s why the 6 columns (2 columns per table) However, I would like to combine the six columns into 2 columns, one [...]
Answer Question
| August 17, 2011 8:41 AM
Access 2003, Access 2003 date query, Access 2003 forms, Access forms
How can I email a query output from Access 2003?
I have a query that runs form a table, the table have data for multiple customers, I give the query the customer numbers, it gives me the customer statement, I then copy and past the statement to excel and email it to the cutometer. I need to automate process if access allows me to do [...]
Answer Question
| January 3, 2011 4:06 AM
Access 2003, Access Database, Access query, Automation
I have a query that runs form a table, the table have data for multiple customers, I give the query the customer numbers, it gives me the customer statement, I then copy and past the statement to excel and email it to the cutometer. I need to automate process if access allows me to do [...]
Answer Question
| January 3, 2011 4:06 AM
Access 2003, Access Database, Access query, Automation
Combining Access 2003 Queries for Dates Criteria
I have a MainInfo table and 3 different Log tables (PleadingsLog, LitigationLog and DiscoveryLog) that are linked to the MainInfo table by an IDnumber. Each of the log tables contains a date field and a notes field. I am trying to find a way to query all records from the MainInfo table that show a [...]
Answer Question
| December 14, 2010 12:43 AM
Access 2003, Access 2003 date query, Access query, Access Tables, Windows XP Professional, Windows XP Professional SP3
I have a MainInfo table and 3 different Log tables (PleadingsLog, LitigationLog and DiscoveryLog) that are linked to the MainInfo table by an IDnumber. Each of the log tables contains a date field and a notes field. I am trying to find a way to query all records from the MainInfo table that show a [...]
Answer Question
| December 14, 2010 12:43 AM
Access 2003, Access 2003 date query, Access query, Access Tables, Windows XP Professional, Windows XP Professional SP3
Exclusive access to Access 2003 database
I have a database located on a server. I have it set to where user clicks the icon and it will open to a main menu. I have one user that when they click the icon and the database opens, they get the message “You do not have exlucive access to this database at this [...]
Answer Question
| December 7, 2010 8:34 PM
Access 2003, Access Database, Access database permissions
I have a database located on a server. I have it set to where user clicks the icon and it will open to a main menu. I have one user that when they click the icon and the database opens, they get the message “You do not have exlucive access to this database at this [...]
Answer Question
| December 7, 2010 8:34 PM
Access 2003, Access Database, Access database permissions
How to pick a source for a subform in Access 2003?
I have 3 different DB-s, I am working with. I have no problem linking the data in. The user is in DB-a. My problem is I need the little bit of tricky code to check my DB-A’s plainid the DB the user is in. To check the DB-A’s planid against DB-B’ plainid then use the [...]
Answer Question
| November 29, 2010 2:13 PM
Access, Access 2003, Access 2003 forms, Access Database, IF statement, Microsoft Access subforms
I have 3 different DB-s, I am working with. I have no problem linking the data in. The user is in DB-a. My problem is I need the little bit of tricky code to check my DB-A’s plainid the DB the user is in. To check the DB-A’s planid against DB-B’ plainid then use the [...]
Answer Question
| November 29, 2010 2:13 PM
Access, Access 2003, Access 2003 forms, Access Database, IF statement, Microsoft Access subforms
reformatting a multi-tab spreadsheet and access 2003
Hi, I have an instance where I have an Excl 2003 spreadsheet and need to reformat it into a single record format using the data from each of the tabs but I also need to put additional data into the new record. Here is another twist I want to be able to trigger this from my access [...]
Answer Question
| December 1, 2010 2:41 PM
Access 2003, Excel 2003, Excel worksheets, Record Format Level Identifier
Hi, I have an instance where I have an Excl 2003 spreadsheet and need to reformat it into a single record format using the data from each of the tabs but I also need to put additional data into the new record. Here is another twist I want to be able to trigger this from my access [...]
Answer Question
| December 1, 2010 2:41 PM
Access 2003, Excel 2003, Excel worksheets, Record Format Level Identifier
Can an Access 2003 query exclude the results from a previous query?
I have a database with 2 tables: one with name/address info, and another with info on yearly donations to our organization. The 2 tables are linked through an ID number. I have set up a query that will give me name/address info for those who donated in 2010 (where the year field is 2010 and [...]
Answer Question
| November 17, 2010 7:37 PM
Access 2003, Access Database, Access query, Query Parameters
I have a database with 2 tables: one with name/address info, and another with info on yearly donations to our organization. The 2 tables are linked through an ID number. I have set up a query that will give me name/address info for those who donated in 2010 (where the year field is 2010 and [...]
Answer Question
| November 17, 2010 7:37 PM
Access 2003, Access Database, Access query, Query Parameters
How do I count specific numbers in an Access 2003 database table?
I have over 6700 numbers in one field. No other fields in database. I want to find out how many times there is a number 1, 2, 3, 4, etc. in this list of possible numbers. I am not proficient in Access like you all are and am lost on creating a report with the [...]
Answer Question
| November 18, 2010 2:16 PM
Access 2003, Access Database, Access Database Design, Access Database Filters
I have over 6700 numbers in one field. No other fields in database. I want to find out how many times there is a number 1, 2, 3, 4, etc. in this list of possible numbers. I am not proficient in Access like you all are and am lost on creating a report with the [...]
Answer Question
| November 18, 2010 2:16 PM
Access 2003, Access Database, Access Database Design, Access Database Filters
Old Recovering Access database password
A client of mine worked on a database 5 years ago for a research project, but she had to quit for a while for cancer treatments. She’s now responded well enough to go back to the project but her database, done probably in Access 2003 (perhaps even an earlier version, but certainly not a later [...]
Answer Question
| November 5, 2010 1:08 PM
Access, Access 2003, Database security, Password recovery, Windows XP SP3
A client of mine worked on a database 5 years ago for a research project, but she had to quit for a while for cancer treatments. She’s now responded well enough to go back to the project but her database, done probably in Access 2003 (perhaps even an earlier version, but certainly not a later [...]
Answer Question
| November 5, 2010 1:08 PM
Access, Access 2003, Database security, Password recovery, Windows XP SP3
How do I copy an Access 2003 database and table?
I’m using Microsoft Access 2003. How do I copy a database and table? They were set up by someone that’s no longer with the company.
Answer Question
| October 27, 2010 5:29 PM
Access 2003, Access Database, Access Functions, Access Tables
I’m using Microsoft Access 2003. How do I copy a database and table? They were set up by someone that’s no longer with the company.
Answer Question
| October 27, 2010 5:29 PM
Access 2003, Access Database, Access Functions, Access Tables
Access Report Headers
I have a problem trying to display a report header at the correct time on a report I am building in Access (2003). Lets pretend I have a report with 3 levels (cuz I do!!!): Proposal, Supplier and Parts. The report is for the Proposal. It is grouped by Supplier and then has a subreport [...]
Answer Question
| October 25, 2010 5:27 PM
Access 2003, Access reports, Header files, Microsoft Access subforms
I have a problem trying to display a report header at the correct time on a report I am building in Access (2003). Lets pretend I have a report with 3 levels (cuz I do!!!): Proposal, Supplier and Parts. The report is for the Proposal. It is grouped by Supplier and then has a subreport [...]
Answer Question
| October 25, 2010 5:27 PM
Access 2003, Access reports, Header files, Microsoft Access subforms
