Hi All, In AccessXP I have a form that as several textboxes on it and I wanted to check the spelling of one of them so I added this vba code in...

bobh

08-05-2009 09:25 AM
bobh

I have a query that returns every fifth record after clicking a command button. The query returns the correct number of records, but an...

zufie

08-05-2009 08:52 AM
Krzysztof Naworyta

I tried to look around but could not find: A feature that dismisses the main form after a pushbutton click on that form that opens a second...

AA Arens

08-05-2009 07:12 AM
Krzysztof Naworyta

I've spent half the day on this and can't make it work. I'm using A2003. I have a report on the screen in print preview mode. Using a button on a...

Wayne

08-05-2009 12:25 AM
Wayne

I just started getting the error message: "is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is...

AndrewBerry

08-04-2009 10:44 PM
Salad

I am busy with a helpdesk database and the calls form has (beside several other fields) two comboboxes: 1st line and 2nd line support, both taking...

AA Arens

08-04-2009 09:17 AM
Wayne Gillespie

Is it possible to programmatically search the code behind the forms, reports and modules in Access? Thanks. Vincent

Vincent

08-04-2009 08:53 AM
Salad

I am looking at ways to record users logging into the database. Currently there is no log on requirement. I am looking at having User Id and password...

Duncan

08-04-2009 08:38 AM
Ron2006

I am trying to get my Dcount Mod5 in my query to return every 5th record. Here is the: Field Name: Expr1: DCount("","IBCCP Referral"," <= " & ) Mod...

zufie

08-04-2009 02:06 AM
Phil Stanton

Hi All, I am attempting to create an auto update feature within a current database. Its a database that logs training for registered...

DeZZar

08-04-2009 12:56 AM
DeZZar

I do have three buttons within a Frame, one at a time can be active (push down). I do have a field that mention the date and time a new record was...

AA Arens

08-03-2009 09:52 PM
AA Arens

I have a table (tblCheckDates) with Date, Location and Name in it. I have a form for entering the Date, Location and Name. In the code I have...

RCGUA

08-03-2009 08:58 PM
RCGUA

I have an Access 07 database with several tables that need to be renamed. When I rename them, all objects associated with the tables refuse to work...

Ryker

08-03-2009 04:23 PM
Ryker

Hi All, I've got a report in Access that has an unbound OLE chart that is getting it's data from a query. The chart and information shows just fine,...

kevinfbutt

08-03-2009 03:04 PM
kevinfbutt

Can anyone help with writing a query to find retrieve the start and end dates from a group of dates. For example a record in the table the data will...

RCGUA

08-03-2009 09:50 AM
RCGUA

The detail section of a report consists of a subreport. The detail section subreport consists of a record and another inside subreport. No matter how...

Steve

08-03-2009 04:29 AM
Keith Wilby

Dear reader, I have an Access application which working with a Front-end and Back-end. In case Front-end (program) and Back-end (data) runs on a...

Simon

08-02-2009 09:58 AM
Salad

I have a form. How to add code so that a default find-record button upon activating directly: - set "Look In" to the right column of the table -...

AA Arens

08-02-2009 03:14 AM
AA Arens

I am looking for a description on how to make reports based on chosen values on a form. I know how to make a report and with a query to make a report...

AA Arens

08-01-2009 09:55 AM
AA Arens

I can make Toggles and Command fields gray but it failed with text boxes. Why? This is a sample of my code: If Nz(Me!Combo154.Value, "") = ""...

AA Arens

08-01-2009 09:46 AM
AA Arens

I am looking for a way to delete the value from either a textbox or combo box by a button on a form and the action to delete applies to the textbox...

AA Arens

08-01-2009 09:30 AM
Salad

I do have a three Comboboxes on my form. Two last are depend on the first. This is the code in the afterupdate of the first combo: cboRS1 = "...

AA Arens

08-01-2009 02:01 AM
AA Arens

To bring my question down to the simplest case - I have a table with two records and two fields. The field names are FirstName and City. If record 1...

Sheldon

07-31-2009 12:09 PM
Sheldon Potolsky

I have a push button that adds the value from a combobox in a text box. How to get an alert (message) if the value in the combobox is not set...

AA Arens

07-31-2009 06:58 AM
paii, Ron

I've written a billing system for a restaurant in Access 2003 for which data entry is performed through the keyboard. The Restaurant Owner is now...

Prakash

07-31-2009 12:23 AM
Tony Toews [MVP]

Hi All, I am trying to create a button on a form that will increase the form hieght and then move a group of buttons into the newly expanded section...

DeZZar

07-31-2009 12:18 AM
Tony Toews [MVP]

its pretty basic really....I want to create two queries to run one after the other: first is an append, second is a delete. Exected via an...

DeZZar

07-30-2009 11:18 PM
DeZZar

I am trying to automate a process which would call a ASPX web page and download a resultant MDB file to a local folder on my server. I am trying to...

SteveB

07-30-2009 06:48 PM
lyle fairfield

Hello All, Im a rookie and this is my first post and probably a very easy question. Here it is: I am trying to hide/show columns based on a combo...

GeoSPoRe

07-30-2009 05:10 PM
MGFoster

I want to Activate/Enable Multiple users on a Access database at the same time. The database does not allow multiple users to add or edit records...

zufie

07-30-2009 02:25 PM
Tony Toews [MVP]

Hi, I am using a slightly tweaked version of the Microsoft form based audit trail. My problem is it willnot work when checking a checkbox. It works...

bob

07-30-2009 12:19 PM
bob

Hello Everyone: I have a field EndDate in a record - the field is defined as Data Type Date/Time. I need a count of all records where EndDate is in a...

AKN_39

07-30-2009 09:57 AM
AKN_39

In various databases I have a need to send data to excel. This issue at this point IS excel. A field will be formatted as text so that "0034" will...

godiva

07-30-2009 09:00 AM
Texascacti

User adds data to a subform on the switchboard of an Access 2003 database. The previously added data does not show on the form header of another form...

zufie

07-30-2009 08:56 AM
zufie

We have a published application (Access front end linked to Access database) made available on a Citrix server farm. All servers are Win 2003. This...

Bill E.

07-29-2009 07:15 PM
David W. Fenton

I have an excel spreadsheet (a dump from another database) which I'm importing into one table; the fields are named: name, scenario (there are 3),...

The T

07-29-2009 05:19 PM
Salad

How can can code be run for each row in a two column report? For example, 1 record = 1 row 2 records = 1 row 3 records = 2 rows 4 records = 2 rows 5...

Steve

07-29-2009 04:21 PM
Larry Linson

How come I get the time in hrs/min/sec while the with the mask input wizard I get 00:00;0;_ as mask. Other similar textboxes give the right input...

AA Arens

07-29-2009 04:11 PM
Larry Linson

If you were asked to survey 1000 people and collect information for your Access database, how would you do that? Let's say its about 10 questions,...

Salad

07-29-2009 01:40 PM
Tim Mills-Groninger

I use these code in the afterupdate event of a combobox to let the cursor jump to another field and also to avoid it default highlight the contents...

AA Arens

07-29-2009 11:54 AM
Marshall Barton

Hi, I am using Access 2000 and am trying to import a TXT file that is Fixed Length. IT appears when reaching the Access database it is cutting out...

bcap

07-29-2009 03:00 AM
Larry Linson

Hi, I have created a Training database. Employees need to enter their training each month. I have created three tables: Employee, Unit,...

Monika

07-29-2009 12:04 AM
MGFoster

We get certain quarterly data in column-width format.. I hate having tor respecify the file layout every time and we would make fewer mistakes if it...

vjp2.at@at.BioStrategist.dot.dot.com

07-28-2009 11:32 PM
MGFoster

Newbie question. In A2003, I select from the menu Help/About and I see the version and the SP that I have; A2003 SP3. Is there a way to see the...

Salad

07-28-2009 06:21 PM
Salad

Hi All, I am using Access as a quickie front-end to our Oracle databases. One of our procedures writes the Oracle RowID to a custom column called...

jonceramic

07-28-2009 05:48 PM
jonceramic

how would I get the most frequent part of a feild (telephone cntrex). I have some idea how to use "ORDER BY COUNT DESC LIMIT 1" but what if I want...

vjp2.at@at.BioStrategist.dot.dot.com

07-28-2009 04:12 PM
Salad

Hi had 2 questions: 1)What is the best way to transfer data that was entered into an MS Access 2003 database by using Access 2007?! (User opened her...

zufie

07-28-2009 03:37 PM
zufie

Hi had 2 questions: 1)What is best way to transfer data entered into a MS Access 2003 data using Access 2007?! (User opened her Access 2003 database...

zufie

07-28-2009 03:30 PM
zufie

I have a selection of SQL queries I'd like to be able to email as a collection so others can import them without my having to copy the entire mdb...

vjp2.at@at.BioStrategist.dot.dot.com

07-28-2009 01:17 PM
vjp2.at@at.BioStrategist.dot.dot.com

I am pretty certain I have used this database from newer versions of access withour problems but I only have PRM and DBF files and no IDX file, which...

vjp2.at@at.BioStrategist.dot.dot.com

07-28-2009 01:14 PM
vjp2.at@at.BioStrategist.dot.dot.com