Getting Started

How do I call a Private Sub MyCode() from another place ?
If I have a Sub defined; Private Sub UID_GotFocus() Me.CSSales.SetFocus End Sub How could I call this Sub from another Sub or from another field event ? Thanks ... 19 Jun 2008 06:30

Using a calculated Field instead of AutoNumber
I am having all sorts of problems with AutoNumbered fields - they seem to have their own method of deciding their value and I am not in control enough so..... I want to calculate my own - I have change the UID field in my Table from AutoNumber to number - I have some code on my Form in the 'On Open' method l... 19 Jun 2008 14:45

Count query
I am used to the Countif function in Excel, whereby if I use “=countif(a:a,a2)” in an adjacent column to a column of sorted transaction numbers, and copy that function down against all the rows of data in the first column, the result gives me the number of times against each transaction number that number appea... 18 Jun 2008 23:02

win2pdf mail helper loop problem
Here's what I'm trying to do..... I have a form who's recordsource is a query that pulls records with a date of 30 days before today's date. In the OnOpen() Event of the form, I have placed code that uses the information from the form to build a report. The report is then e-mailed to the e-mail address on the... 18 Jun 2008 23:02

Showing Items with no values--Simple Question I hope
I need to make a query (ultimately a pivot chart) that shows all the departments in my place of work. The query must also show whether they did or did not submit a report. If they submitted a report, I have the data. I can run a query that shows all the departments that submitted data. But I need the quer... 21 Jun 2008 17:53

starting up
hello i am a beginner in access ...can you please indicate me a usefull site where i can start collecting some knowledge ? thank you ... 17 Jun 2008 18:17

MS Access 2003
I'm very new and do not know much about it. But i had someone make me a database for my small co. I rent Lamps to Movies Industry . Most of the lamps have a # Like VT095 Ect TT200 . And on . When i enter all that and Hyperlink them to the picture . from my desk top Computer .Then I want to be able to do the sa... 17 Jun 2008 19:49

how do you close a data entry form without saving record
I need to know how to close a data entry form using macros without saving the data in the form such as a cancel button on the form ... 17 Jun 2008 18:17

Still Struggling...
Hi, I'm still struggling to organize my tables and fields but I'm not as *totally confused* as my original post; at least I hope I'm not. I'm new to Access. This is my first database and I fluctuate between feeling hopeful I can do this one minute and despairing that I can't the next because I've thought of ye... 18 Jul 2008 15:28

Validating Text on an Entry Field
I am allowing a user to edit one of the fields shown on the list, but in a bound field underneath it - this works fine - however I want to validate his entry based on the values in some of the other fields in the currently highlighted record - some of these are calculated. I want to do something like; FieldB... 19 Jun 2008 12:41