Microsoft Access / VBA Forum

I have running one application (.mde file) of MS access 2003, quite a long time on Windows XP, - it was working well. Recently on my PC was installed SAS, after that while running my .mde application I am getting message "Automation Error -- Library not registered". I have found in WEB one recommendation - register module msadox.dll....

I have a MS access 200 DB in which I have an update query which repalces all the " " with ''" in a field. I would like the update query to run in the background, and not ask the user for any perrmissions. I was thinking to run the query as part of the autoexec macro. can anyone recommend a way that I can have the update query run in the...

Good afternoon folks, I'm a total novice at this game. I'm a student at an University in DC and is taking a basic course in Access and database. I need some help writing a nesting expression using Isnull and iff functions. I have a field titled "Revision_box" that would display either 0,1,2, or 3 depending if certain fields are empty or has...

I am having a hard time doing the following in a query. I need my field "EarnedValue" to return the result depending on other fields. The code in VB would look like this: If > 0 and = false then = *.5 elseif = true then

Is it best practice to set Unicode Compression to "No" for memo fields in a table? What about text fields? According to the VB help entry: "Data in a Memo field is not compressed unless it requires 4,096 bytes or less of storage space after compression. As a result, the contents of a Memo field might be compressed in one record, but...

Hello, I am using Access 2003. Is it possible to use string variables in the INSERT INTO statement? I am using the INSERT INTO statement to add a long list of contacts to a group by looping through the recordset (based on a linked spreadsheet, 'tbl_group_import') and using the INSERT INTO statement on each loop. I am using the...

Hi All, I'm trying to create a single code (run off a button that calls the Private Sub) for our parts list report that will allow the user to filter by either/both PartVendor and PartType. On the microsoft forum I found multiple examples of code from HansV and simliar code from NeoPa here that I am trying to understand and adapt. The...

I have worked for hours on trying to find a solution and have not figured it out. I am working in Access 2003. I need to create a query that takes values from 1 table and displays them in multiple fields. I don't have the option of changing the structure of the existing tables because I am importing them from a separate data source on a...

Greetings, I'm trying to utilize VBA to set a subform's recordsource on a command button click. My form is used to search by a query and display the results in the subform. If I set the subform source in the property sheet it works properly but loads the full query on opening the form. I want the subform to be blank until I click the search...

Hi all, I have query about passing a parameter from form to a query. My situation is as follows: I have a query that pulls up some data from a table, however there is a condition that must be filled in by the user. Hence when you run the query there is a "Enter Parameter Value" prompt that must be completed. A further complication is...

A form contains controls, one or more of which can be other forms. A form that contains another form is known as a main form. A form contained by a main form is known as a subform. A subform itself can contain other forms, sometimes known as subsubforms. This article deals only with main forms and their immediate subforms. The books about...

Hi, Is it possible to export the design of a table to Excel (e.g. Field Names, Data Types, Descriptions)? Thanks, Laura

This one is stumping me! I have a Form/Subform arrangement. The main form is set as a Single Form and the sub form is set as Continuous Forms. On the Form_AfterUpdate event of the subform, I run some code that affects the main form which forces focus *away* from the subform and puts it to the main form. I need to keep focus on the...

Hello all. I'm new to access and am trying to create a calendar/schedule in access. Yes I know there's a bunch of other ways and software to use, but I want to keep it together with the database I already have. I'm new to access and know very little about "coding" (vba) or anything else. Point and click I'm good at. LOL Here's what I'm...

I would like to clear out all the records of a table using VB Code. I am building the table on the fly, so that I can cross reference it with my main table. The table consits of a multiple 3 digit numbers, depending on the check box the user clicks. The DB name is FalconAnalysis, the table name is UnitSize and the only field in the table is...

Working on converting some old MS2000 access applications to MS2007. I have many datasheets in the application and I have noticed that on all of them the column headers have a down arrow with sort/filter options. This arrow is covering up some of the letters on the column descriptions. I have built-in listboxes on my forms that allow the users...

Hi, I've got an input form (frmInput) that can be accessed in two ways. A combobox on this form either gets filled in by a selection on an already opened form (frmBasic), or one can input a value manually after opening the frmInput directly. Is there a way in VBA I can detect if the frmInput is opened based on a selection on frmBasic or if...

I have been given a database on a CD to do some work on. The only problem is that when I open a form it tells me that the file path //server/database/mydb.mdb is not valid. Of course it isn't valid the whole thing is on my comp at the moment and not even on a network. How can I change this path so that I can work on the database locally...

Hello, I'm stumped and I'm hoping someone could help me figure out the best way to track daily attendance for the next 6-4 months. I have a list of 80 or so participants who should be attended training on a daily basis and am tracking if they attended, have an unexcused absence, or are absence with an excuse. At the end of the month, I...

Hi, I am working for a company which as a MS SQL backend and Access as front end. We update automatically each access db on the user local machine when a new feature has become available. We have to stay with MDB for several reasons, so please avoid telling me "you have to convert to MDE"... It is not an option. We need to allow our users...

I have a multi relationship database and I'm pulling the company's contact info, queryied if they are a grower, and a resulting list of their products by catgeory. I need to have the products listed all together in one field. Example: CompanyName Grower Category Product B Orchard -1 Fruits Apples B Orchard -1 Fruits Blackberries B...

I found that there is something like Sum(), and I get that.... I have two columns that are populated via check boxes on the form called 'Sent' and 'Signed'. Once checked, the value in the table is a -1. I need to divide the total sums to get a percentage of signed vs. not signed. In Access, what would be the formula I enter in the query...

I have a database that is keeping track of returned mail. Each piece of returned mail has a status. I want to be able to view reports for all the returned mail in each status. I could create a button for each, but I would rather select the report from a ComboBox or ListBox. I have the combobox getting its values from a statuses query. I don't...

I am trying to extract numbers from a string in the access query builder, all I need is the position of the numbers so the instr function will do. However I need a code like InStr(.,"") where ] "" can be any number from 0 - 9. I can't figure out what to use as a wild card for numbers. Please help Thank You

Hi, Suppose I have a date, is there some way I can use Access to calculate the week number the date is in? And if so, can Access take notice of leap years? Thanks!