Microsoft Access / VBA Forum

i am having an access database and have created a table named RECORDS which has the following fields cust_name......(customer name) items..............(items) date_pur..........(purchase date) cmp_name......(company name) Now i have a form through which i input 2 dates

My question is related to Access forms. I have set up an Access form using 4 different tables~I am pulling 2 different numbers and the name of Trusts out of one table, I am pulling custodian name and acct number from 2nd table, 2 different numbers from Investment manager table and then 3 empty fields (at this time-needs to be populated by form)...

Hi, I need some help. The routine below runs when a command button is clicked. A prompt appears to enter the directory path to the folder containing delimited text files to be imported into an Access 97 table. The test folder contains 9 files. The problem is that the 1st file is imported 9 times into the table. How do I correct the routine so...

I am begining to work on a VBscript to use inside a MS Access Query, so I started to do a little looking around the web to see if there was already a built-in VB function or at lease an example of one to convert a large number (6 sign. digits & larger) into SN (Scientific Notation) format for manipulation later within my script. Example: Input...

I have an Access form (MainForm) that has a SubForm. I would like to know if a MainForm event exists that detects a SubForm record change. I can use the "On Current" event to detect when the MainForm record changes, but does an event such as "On SubForm On Current" exist? Many thanks,

My table has a record called date/time - filled (not surprisingly) with a date and time. I can format the date in one query field, also the time, using format in an expression. My user wants me to provide a listing of all table entries between 22:00 and 07:30 the next day, between a given set of dates (typically one week apart but in...

I am new to this site. I have searched and found similar posts but don't think they are answering my question. I have a basic and simple DB. 4,170,000 records each record being 6 fields. File size is 1 Gb. Monthly I have our I/T person provide me a txt file. I then use an Import Spec and import the data into my table. Over the last 4...

In one of my databases, I have a name field where I recently came across a problem. Someone had entered the person's nickname inside double quotes. This works until I come to the part where I create a report and try to save it as a PDF with the name field as part of the file name. For example, the name could be James "Jim" Doe. My first idea...

Does anyone knows the odbc driver / string to connect to Access 2007 file (.accdb)? I can't find it anywhere...

I've done a lot of database work, but only scratched the surface with Access. I'm trying to write a macro (executable on-click from a button on a form) that will clear a subset of the current record's fields. My macro is pretty simple-minded: It has eight actions (all SetValue), each one associated with one of eight fields ("items",...

Hello all! This is my first posting here, although I've been lurking here for months and getting lots of help & tips from the past posts here. I'm in the process of updating our company's Access 2003 database to 2007, and while we're finding some of the new perks to be neat, I'm having a problem getting some of them to behave as we've...

I have a child combo box whose values depend on a user selected value in the parent combo box. If the child row source query returns no rows, the listcount property still is set to 1 in Access 2003. And if the query returns 1 valid row, the list count is set to 1. I need to set the enabled = False on the child combo box if there are no valid...

I am writing a vb.net app that uses ms-access as its database. I need to allow users to create their own custom sql expressions that will eventually be used in their reports. After they have created their expression, I will store the expression in a db table (as a string). Now when they go to create a report, they can choose one or more...

Hi Guys I need to set up or create a routine will keep a log file of what was done by whom Is there any easy way or is it implemented already in Ms access 2007, i need a log file which keeps track of any interaction(abcd) with the database Any idea, somebody already did it, any example, please let me know

I wanna execute a query with one parameter from MS VBA. the trouble is that the parameter is a control in a form. and I still don't know what is the code I need...

I have problem creating Access (Continuous) Form with indepenent CheckBox for each record. The user should be able to select records that will be processed by VBA based on ChceckBox value. When I use Table as a source then there's no problem. I have field of Yes/No values, and I'm able to select each record inependently. But when I want to use...

I created a group of option buttons using the wizard. Now I want to decide which action to take based on which option was selected, I can't seem to find the syntax testing which button is selected. I thought maybe something like: "IF !!=1 THEN..." would work, but it says I entered an expression that has no value.

Hi, I would like to add a button (outside of the subform) or a double click on text box (inside a subform) to add an attachement (pdf, word, excel). I was told i can use the OLE Object, but I could make it work. thanks in advance

Most Access Users fail to realize that they can significantly enhance their applications by introducing various sounds (*.WAVs) in response to specific events. The only intrinsic sound that Access can generate is the DoCmd.Beep which is hardly worth the time to mention. You can incorporate sound functionality into your Access applications via a...

Hello... thank you for your time. I have a form that has a List box of equipotent records and a sub form that will show the data of the equipment select from the list box. Is it possible to make a change in the name field in the details, then refresh the list box with new name? Please help and thanks!

Hi all my favorite Access elves, and happy NewYear. Im trying to modify a tabledef by code, and I seem to be running into some trouble. I am still in the early phases of getting an understanding on how to do it, and im allready stumped at simply refering to the tableDef. I have tried this: With CurrentDb.TableDefs("hist_tbl_Obs") ...

Please help me for the following program problem. When I Click Next button, at the last record, it Shows --Run time error '3021': Either BOF or EOF...... Option Explicit Dim strsql As String Dim con_data As ADODB.Connection Dim rs_Data As ADODB.Recordset Private Sub Form_Load() Set con_data = New ADODB.Connection

What is the code to cycle through the fields of a recordset starting at the second field through the last field when the index of the last field is not expliciyly known? Thanks for all help! Steve

Hey, all. I've tried both of the following methods, but neither is working. Suggestions? =IIf(=0,,IIf(=,,IIf(<6,,0))) =IIf(=0 Or (=) Or <6,,0) Basically if any of the conditions are true, insert , if not insert 0. Whenever I add the option everything breaks. Thanks!

I need to convert a string "20040129" to a date format "01/29/2004". How do you do this?