I currently have a form which contains a macro. When a button is pressed, the macro opens up another form to allow a user to add data. When the form...

Simon Argent

11-17-2007 01:04 PM
Ed Robichaud

I have a requested date field which is a date, I need to create a form with start requested date and end requested date with who it was...

Elainie

11-17-2007 11:58 AM
Ed Robichaud

Is there a way to make a report that works like an excel spreadsheet? I want to record a set of values related to sales data every day and then see...

KitesLive

11-17-2007 12:46 AM
sirdaveo@yahoo.com

Hi: WHen I bought my new computer I only installed A97 and A2003, since those are the versions I use. However, a utility I depend on (SpeedFerret)...

Jan

11-16-2007 11:55 PM
Tony Toews [MVP]

Hi can someone give me a hand with this please? I'm trying to build a search filter that scans through a list of client names in a database as you...

Cron

11-16-2007 03:05 PM
Cron

I've seen a lot of posts asking how to get Datasheet-like functionality into a Continuous Form. One of the obvious missing elements is adjustable...

Lauren Quantrell

11-16-2007 01:49 PM
Lauren Quantrell

I have a form that opens another (intermediary) form. The user selects an option on the intermediary form and it opens another form and...

Salad

11-16-2007 08:38 AM
Salad

This was an interesting problem. I open a form, CalledForm. When a record is presented in CalledForm I needed to check the status of something. If...

Salad

11-16-2007 08:34 AM
Salad

How do I able to locked users from pasting records from column datasheet to another column? My case is I have a form that has a check box that...

JML

11-16-2007 07:26 AM
lyle fairfield

I recently had a motherboard failure that took the drive with it. When I finished reloading everything on the new system, I have a new problem. I...

KC-Mass

11-16-2007 12:50 AM
Stuart McCall

Hi Again, Throwing this one out to you again as i am not getting anywhere and can find little to no information out there. I am currently...

redpears007@hotmail.com

11-15-2007 07:34 PM
Stephen Lebans

I have a field that records whether an Employee is permanent or temporary. My thought was to simply have 1 field that if checked means that the...

tbrogdon@gmail.com

11-15-2007 02:41 PM
tbrogdon@gmail.com

Hello, I know that I can use the Parent property to get the name of the form that a subform is on, but what if I need the name of the...

Dave

11-15-2007 01:03 PM
rquintal@sympatico.ca

Hi Using Access 2007 and Windows XP I get the Error : Can't complete the output operation Error occurs whe I use the sendobject or...

Alfred

11-15-2007 10:17 AM
lyle

I seemed to have lost the ability to move my mouse over a variable in my VBA code and have it's current value displayed. There's probably a setting...

Sheldon

11-15-2007 09:25 AM
Sheldon

Thanks guys, that worked. I was incorrectly using the # placeholder for a number datatype

gavm360@yahoo.com

11-15-2007 08:25 AM
gavm360@yahoo.com

Hi all, can anyone help me with this one? I have a database that has multiple linked tables and i want some code to tell the database on startup to...

redpears007@hotmail.com

11-15-2007 08:01 AM
Keith Wilby

Sagekey is almost there but below is the more advanced solution, although no software is hackers free as they claimed. But for ms access access...

softndesk@yahoo.com

11-15-2007 06:11 AM
eyoung24@gmail.com

My application has a form based on a parent table with a subform based on a child table. The relationship is Cascade Delete. The first record...

brucedodds@comcast.net

11-15-2007 06:01 AM
brucedodds@comcast.net

Does anyone know how to add a reference to an access database (db2) programmatically to a main database (db1) if the library database (db2) has a...

alan@cossey58.freeserve.co.uk

11-15-2007 05:52 AM
alan@cossey58.freeserve.co.uk

I'm deliberately posting this message in this group, so please don't flame me....Does anyone have any experience with the training that Microsoft...

Vincent

11-15-2007 01:08 AM
Larry Linson

I have a table i use to store scores for employees. EMPID Q1 Q2 Q3 1234 3 2 4 Q1,Q2 & Q3 being the separate questions and the...

Toby Gallier

11-14-2007 11:44 PM
tina

OK. I hve myform1 where the user inputs Date, ShiftNumber, and Department which all taken together define the ProductionID. myForm1 also has a...

tbrogdon@gmail.com

11-14-2007 11:43 PM
tbrogdon@gmail.com

Both: it records the date and time of the new record, the name of the user who saved it, and the value of the fields at the time it was saved. It's...

Allen Browne

11-14-2007 11:02 PM
Allen Browne

HI Using Access 2007 Can I open the calendar that automatically appears next to date fields with a keyboard shortcut as I dont want to use the...

Alfred

11-14-2007 07:40 PM
ARC

This is cool. Found this site Find People Free Search. It is a free people search site. Sign up is...

snz4qmnrilujjixyfunt@gmail.com

11-14-2007 03:43 PM
snz4qmnrilujjixyfunt@gmail.com

Hi Group (fairly limited knowledge of Access and almost none of Access VBA. Using Access 2003). I need to sum time, I've found through the groups...

dwasbig9@gmail.com

11-14-2007 01:39 PM
dwasbig9@gmail.com

I have 2 fields one completed date and the other a combo box with 4 headings, completed is one of them If completed is selected and the date hasnt...

Elainie

11-14-2007 01:26 PM
Salad

I am working on a database someone else created. I need to modify the code for the order number field. I need the input mask to be "B-000000". It...

clk

11-14-2007 12:08 PM
J_Goddard via AccessMonster.com

I have a query that simply totals a number of fields from a linked table. If I run it several times, it works fine for a couple of runs and then...

jgscott3@bellsouth.net

11-14-2007 10:02 AM
OldPro

Hi all, I have a problem. I have designed a search form in Microsoft Access 2003, which contains a subform that displays the results. The search form...

chuch

11-14-2007 09:41 AM
OldPro

Hi NG, I have to face severe problems when I open a Access 2000 Database with the Access 2000 Runtime on a computer where Office 2003 is...

Wolfgang Kaiser

11-14-2007 09:27 AM
Wolfgang Kaiser

I've implemented this suggestion very successfully in a full-featured MS Access database at my place of employment.

Don Calloway

11-14-2007 07:56 AM
Ron2006

I'm using the following code to check for duplicate names when I exit the field "MemberName" on a form: If DCount("*", "tblMembers", " = '" & Me!...

Wayne

11-14-2007 06:23 AM
Wayne

Is there any way to by-pass the limitation of only 8 items on the switchboard menus? Thanks!

David Grist

11-14-2007 03:46 AM
alecwood via AccessMonster.com

I have an Access 2007 form timer event that (seemingly at random times) fails to fire. I also have Access VBA code that slows down, sometimes taking...

11-14-2007 01:56 AM

I am working on a database someone else created. I need to modify the code for the order number field. I need the input mask to be "B-000000". It...

clk

11-14-2007 01:39 AM
MGFoster

I'm having the strangest problem. Anyone ever have problems with committing a transaction on writes that have referential integrity? If I step...

ARC

11-13-2007 05:57 PM
Allen Browne

Hi all, I hope I'm not off-topic. I'd like to ask you if you know of any company that offers Access training (from intermediate level onwards) in...

myemail.an@googlemail.com

11-13-2007 05:50 PM
CDMAPoster@FortuneJames.com

I'm very upset with Google's policy of indexing and allowing Google advertising on forum web sites which are "slurping" content from Usenet and...

Tony Toews [MVP]

11-13-2007 04:59 PM
CDMAPoster@FortuneJames.com

I have a strange problem with a split Access 2003 database that is now sorting the records on an ID number, where it wasn't previously. Until now,...

stuart

11-13-2007 03:25 PM
stuart

I have two tables, A & B. Table B has adjustment factors of three types, "COMM" being one of them. I want a query that generates all rows of table A,...

SP

11-13-2007 12:45 PM
rquintal@sympatico.ca

I have a report to count some statistics of case data. I can't figure out how to make Access group and sum/count information to give me a nice...

nospam@thankyou.com

11-13-2007 10:38 AM
Ron2006

I have a new database file which i have created in my Table i have a field called name where 5 names can be selected from list also have a another...

Mrbanner

11-13-2007 09:56 AM
OldPro

Arvo, I've been reading about the above function, or similar, as it seems applicable to my problem, however I have to admit I am totally lost. What...

Stinky Pete

11-13-2007 08:15 AM
lyle fairfield

WinDBPro. Ver 2.0 Complete DB one exe file only 12 billion Record Capacity Search / Sort / Find Built in Table 9...

Scott

11-13-2007 02:27 AM
Scott

I have a form (myForm) which has the following combo boxes: 1) Shift (selects shift 1, 2, or 3 from tblShift) this value is not stored in a field. 2)...

tbrogdon@gmail.com

11-12-2007 11:54 PM
tina

I have a form in access 2000 with a combo box containing names, this is linked to a sub form by the name index. on the sub form is a button that...

feeman

11-12-2007 07:50 PM
rkc

I kind of get the idea of databases, how the fields and keys work, but Im not very sure about designing one... what should be a field, etc. I've...

benn686@hotmail.com

11-12-2007 07:47 PM
Smartin

Hi Using access 2007. --- MDE All the reports opened as maximised. the minimised restore and maximised buttons is not available. I can print the...

Alfred

11-12-2007 05:44 PM
OldPro