| Thread | Last Post | Replies |
|
| Data Entry | 27 Apr 2007 02:40 GMT | 4 |
I don't know if this can be done using access, or if I would have to write a program to do it.... I am trying to make a database to track the work I do. I can process 8 'samples' at a time, which get stored in groups of 96. I would like to make
|
| insert null date/time | 27 Apr 2007 02:16 GMT | 11 |
Is there any way to insert null into a date/time field? I have a web page that has a date textbox and I want to insert an empty string or null if the user did not enter a date. I am using HTML, ASP, access db.
|
| Key behavior in a tabular form | 27 Apr 2007 01:18 GMT | 4 |
I used the Wizard to create a tabular form based on a query. The tabular format looks good but the up and down arrows don't move me up to the previous record or down to the next record - they move me left or right. Can I fix this? I want the same key behavior as the datasheet view ...
|
| Custom Menus in Access 2007 | 27 Apr 2007 00:50 GMT | 1 |
I know in VB 6 you can create custom pop-up menu. Is there a way to do this in Access 2007? Active X? DLL? Hidden command that I can't find? Any tutorials or direction? Any help or direction that anyone can provide would be appreciated.
|
| File does not open from shortcut bar | 27 Apr 2007 00:42 GMT | 3 |
A recent thread started with a question to see if Office 2k runs ok with the XP OS. The response was returned that it works perfectly. I found this not to be true. If enabled on the shortcut bar, Access (the program) will start the program, then you can select the file you ...
|
| find last historical record | 27 Apr 2007 00:26 GMT | 9 |
Sample list of records: DATE LAST_NM FIRST_NM INT_ID OTHER2 OTHER3 OTHER4 1) 20070301 DOE JANE 12345 XXX XXXX XX 2) 20061102 DOE JANE 12345 XXX XXXX XX
|
| Request From Access | 26 Apr 2007 23:48 GMT | 1 |
I am currently creating a database for work, I am requesting assistance. I want to create a spot on a form where you can click an item and information through that one option comes up. ie. click on 2007 and a person's name and amount of money they have received
|
| Print Access MDB name on reports | 26 Apr 2007 23:47 GMT | 11 |
I have several Access MDB which uses linked files from an SQL server. They all uses the same files, but have different queries, reports, etc. These are for different departments. Some reports are in more than one MDB. When a user reports a problem, or requests a change, I ...
|
| Look for duplicates, rename field value, reconcatenate | 26 Apr 2007 23:08 GMT | 2 |
I want to run some type of query that will concatenate values from three fields: NG2, Corner, and typecode in another field called XPS_name. I then want the query to check for duplicates in the XPS_name field. Whenever there are duplicates, the query should then iteratively assign ...
|
| format date field for imported table | 26 Apr 2007 23:04 GMT | 5 |
I have a table imported from another table that has a text date field. How can I format the imported table date field to date format using vba I guess? Date format for the new imported table field:
|
| Table Update | 26 Apr 2007 22:52 GMT | 1 |
The MS ACCESS data base tables are linked to SQL db's. I need to add a record to a table, the table is not allowing updates, the table is linked to a View in SQL. Could you please tell me how to allow updates...
|
| INSERT date into Access table | 26 Apr 2007 22:45 GMT | 4 |
I am having a bit of problem in populating a table with date as one of its columns. myTable -----------
|
| Database Repair Help | 26 Apr 2007 22:40 GMT | 5 |
I created an Access database in Access 2000 and share it on a WNT4.0 server. Several intermittent times a day the database requires rebuilding when you attempt to open it on one of several workstations. Some of the workstations have Access 2000 and some have Access 2003. No more ...
|
| Fill in the time/date of when an entry was created | 26 Apr 2007 22:24 GMT | 5 |
I have a form that is set up in data entry style which records information from invoices that we receive. I would like to do the following: 1) record the date and time when data is entered and 2) record the date and time that a query pulls data from this table.
|
| Description Function | 26 Apr 2007 22:09 GMT | 3 |
I've used Access2 through 2000. One of the features I've used extensively to organized my action queries is the description field in the database window. I have been testing 2007 and found that the description field is no longer sortable. I used to use this field to number my ...
|