Help
in [Access]
|
Bad Code Needs Help I have a form. When a person selects a publication from a listbox, this snippet of code is supposed to look up authors that correspond to that publication and populate the Author List Box, but it doesn't work. I have been hacking away at it for a while to no avail. Can anyone spot the bug(s)? The RowSource pro... 5 Jul 2006 16:18
Linked Table Manager Can anyone guide me through changing the location of my linked tables through the Linked Table Manager? (MS-Access 2000) Here's what I've done: I'm in the front-end application on a split database of course. I open the Linked Table Manager, Select all Tables, and check "Always Prompt for new location. This bri... 29 Jun 2006 07:15
Booking System Help Hi, I am currently creating a cinema system using access where a booking can be made for a event. Each event when it is shown is categoriesd as a performance. A booking must be made for each performamce. I have a constructed a query between the booking, event and peformance tables and created a subform on the booki... 20 Jun 2006 09:01
Count Days Is there a way I can count days? I would like to place a control on my form that counts the days from the first day of each year. THanks. ... 19 Jun 2006 10:02
Access mde files Work at a large site - 1000+ PC's. Mixture of Win98 & WinXP. Majority of applications using Access 97. If I compile the Acc97 application on a Win98 PC, the .mde will run perfectly on both Win98 and WinXP PC's. However, if I compile on a WinXP PC, the application doesn't run correctly on Win98 PC's. Whil... 21 Jun 2006 17:59
Memory management problem? Greetings... I have some strange problems involving: Access 2000 (9.0.4402 SR-1) Windows 2000 Server 5.00.2195 Service Pack 4 Access apps with Oracle/ODBC back ends One app is a reporting one, and it opens reports (in either View or Print mode) from a master form. The code opens the report first in Design... 14 Jun 2006 01:44
Get the value of SetWarnings Hello, I am suppressing the warnings in Ms Access database by using the DoCmd.SetWarnings=False statement. However I want to get a list of all the Warnings that were generated between a: DoCmd.SetWarnings False and DoCmd.SetWarnings True Please Suggest. Thanks and Regards, Pradeep Varma *** Se... 9 Jun 2006 10:58
Forms: Fill a Field automatically on a form based on a date range Hi, I have a employee vacation database that has a vacation table that has the employee name, pay week and date of vacation. I have another lookup table with pay week code and date range for the week. The user would like to type in a date in the Date of Vacation field and have the Pay Week field automatically fi... 13 Jul 2006 10:45
Duplicate records I have an Access 2000 database with a query in it that is pulling data from a table that has duplicate records in it. It is doubling my currency out put. To get rid of the duplicate records in the table i am contemplating running a 'duplicate records query'. Question is then two fold. One is, is this the best way t... 15 May 2006 11:42
SSN Format query I have a query, here is a brief snipit: SELECT Employment.PERSON_ID, Person.FIRST_NAME, Person.MIDDLE_NAME, Person.LAST_NAME, Person.[SOCIALSECURITY#] AS SSN, .... I want to return only the last 4 digits of the SSN. Can the below snipit be incorporated into the above query? something like: SET SSN = Right$(... 9 May 2006 19:12 |