| Thread | Last Post | Replies |
|
| Need Query by Month when date written as **/**/2004 | 28 Dec 2004 01:21 GMT | 1 |
I need to make a Report of all people starting in 2004 by "Date Requested". Dates are entered as mm/dd/yyyy. I have a query that has all the people that started in 2004, but there are numerous dates/days per month. I need to combine in my Report to show:
|
| Spawning Access from Access | 28 Dec 2004 01:11 GMT | 3 |
Is it possible to spawn an Access program from another Access program with out going to a batch file or something? I would like to have an Access main menu and bring up a different front end Access program depending on the menu selection. I'm using Access 2000.
|
| remove letters and numbers from text box | 27 Dec 2004 21:34 GMT | 1 |
I have a text box called txtDateBox I want to have another text box txtdatelook that takes the date and removes the first 3 digits i.e.txtDateBox has this format 01/12/04 or 22/12/04
|
| Database to a table | 27 Dec 2004 20:34 GMT | 5 |
Hello, I am working with a database that has the columns... place_id - place_class - place2_class Some instances of data are: 1 - 1001 - 1002
|
| Easily go from one data set to another? | 27 Dec 2004 20:07 GMT | 1 |
I've set up a front end and link to a back end where all the data is stored at (sharednetworkdrive)\MyData\data1. On that same back end, I also have another office's data in MyData\data2. And another's in MyData\data3, etc. I would have preferred to set it up as one dataset and ...
|
| Table access via recordsets | 27 Dec 2004 19:22 GMT | 2 |
This is driving me nuts - I 'm trying to open a table programmatically, to add or modify records, and I can't put all the pieces together to make it work in Access 2000. I have all sorts of apps in 2.0 and 97 to self-plagiarize, but the syntax changes
|
| ms access connect to quickbooks? | 27 Dec 2004 18:31 GMT | 1 |
is there a way to connect to quickbooks via any connectors to ms access? if so is there any good places to get this information. the reason for this is that i developed a database to track inventory and parts and would like to experiment with consildating all company
|
| Getting the name of the database, is there a varialbe? | 27 Dec 2004 16:25 GMT | 7 |
I want to display the name of the current database on a report. For example, if the database is "db1.mdb", I want it to say "db1.mdb" somewhere on the report. I could put a label with the value "db1.mdb" in it on the report, but if the database were copied to another name, that ...
|
| How to add minutes to Date? | 27 Dec 2004 16:02 GMT | 3 |
I have a date in this format: "8/27/2004 10:00:00 PM", and I have a Long Integer that represents minutes, such as 15 or 10080. Is it possible to add the minutes to the date and get a date value? How would I convert the values before adding?
|
| Recursive Function with Select Case fails to exit | 27 Dec 2004 06:44 GMT | 4 |
When I loop through this function, it works fine until it hits End Function - then it jumps to End Select. Very strange... This behavior occurs when Case = 255. Any ideas why this is happening? Why doesn't the function just end? Why the jump back in at End Select?
|
| Getting rid of hard coded path | 27 Dec 2004 06:11 GMT | 7 |
I have been running some code from a form's on open event to run regedit if a registry key does not exist in the registry. It has been working fine, but I have had the path to the registry fix file hard coded into the VBA like this.
|
| Database Connectivity | 27 Dec 2004 03:57 GMT | 1 |
Microsoft has a tutorial for ASP. There is a connection string in the code as follows: DBQ=C:\Inetpub\Wwwroot\Tutorial\guestbook.mdb;"\ How do I change this statement once I move the page to my web server? I
|
| Architectures for multi-user access database | 27 Dec 2004 03:24 GMT | 5 |
I currently have a multi-user access database which is put on a shared drive L: on a Windows Servers. Entire database is one file premdb.mdb. Users access this database from their laptops. Following problems occur:
|
| Auto Numbering - Help! | 26 Dec 2004 22:44 GMT | 6 |
No one answered my original e-mail--it probably wasn't clear. I am hoping this makes the question a little clearer. Is it possible to combine both letters and numbers in an auto number? I can't make it work past 9--when it comes to 10 it doesn't work. Here
|
| Please Help Me | 26 Dec 2004 19:58 GMT | 2 |
Please help me dear brothers . i want to design a database which is for a survey. it has a shape like this. surveyeeid Gender
|