General

Can't open my Access files after conversion from Access 97 to Access 2003
Hi, After I converted my MS Access files from ver 97 to 2003, I cannot open them anymore. How can I resolve this problem? I run Windows XP Pro SP 3. Regards M Shafaat ... 10 Apr 2010 16:49

Search Listbox vs Table Query
I have a calendar form in my AC2003 database. I need to verify if the entry in the access calendar is in their outlook calendar. During the load of the access calendar for a month I: 1. load all outlook calendar entries into a listbox with start, end and subject, this happens once per month, then 2. for each ... 12 Apr 2010 14:47

Change default export to Excel location - Access 2007
Hi, Does anyone know how I might be able to change the default location for exporting tables, queries, etc. from Access to Excel? It defaults to My Documents, which I can't stand because it forces me to drill down to find the spreadsheet. I'd rather that I could set it to go to my desktop. I've looked in ... 17 Apr 2010 03:12

List Box - User Edit
I have list box with multi Column, how can I allow the user edits the fields? ... 9 Apr 2010 19:00

MS Access Adding Sequential Numbering
I have a table with the following data Deal ID 1234 Assoc 1234 Associate Role ABC Deal ID 1234 Assoc 4567 Associate Role ABC Deal ID 1234 Assoc 8910 Associate Role DEF I want to number the like roles for each Deal Id so the result would be Deal ID 1234 Role ABC 1 and then Deal ID 1234 and Role ABC 2,... 12 Apr 2010 23:41

totals query - group by email max of date
I'm trying to export our email list and I'm having a problem. I'm working with 5 fields first name, last name, email, date, ip I tried to group by email and max of date, but I still saw duplicates. So I also tried to max of IP and then I did not get duplicates. that's nice but not what I was expecting. When... 17 Apr 2010 10:46

A On Open problem
Hi, The same problem again. On the main ("MainF") form is a subform ("SubF") that displays a datasheet. When displayed, I want the cursor to be set on the first record of the datasheet. I hope I'm using the correct terms ! To do so, in the On Open event of the SubF I put the following line : DoCmd.GoTo... 12 Apr 2010 17:03

Adding Sequential Numbers to a Query
What's the correct format to use DCount function in Access? I'm trying to add sequential numbers to the results on a query that's based on several tables. Does anyone know how to do that? In my query under design view I have a table named “item” which from there I want the field named “No” to be the source to d... 9 Apr 2010 16:46

see Deleted # after run Delete and append query
I have a command button with a macro tied to it that runs 1st a delete query and then an append query to refresh a JOBs to Be at list(TABLE). the queries run Fine but I need to close and reopen the Form based ont this table to get rid of the delete # records and see the new records. where do I put code on the... 9 Apr 2010 14:31

aut generate tab
Access 2003 I have a form called f018ContrPerf Is it possible for a tab to be auto created for each UnitNo field I have within a record? The tab should contain a form called fUnit and the PK is ProjectID, and UnitNo? i.e. if I display a project record with 2 unitNo's then a two tabs are created with th... 10 Apr 2010 00:30