Search results

Hi i am making a training database for my firm so that new starters can get the basics of acccess quickly. I have a form which displays information called from a table and prints clear instructions in a text box. I have also created some screen movies of me doing basic actions so that when a...

Hi does any one know a vb code to split a table using an auto number field say I had 2000000 records and I wanted to choose any table in a form and hit a button that would split the table in two table 1 and table 2 any help would be great thanks

Hi Im trying to link different chapters of a process in my Data Access page so that people using the database can go the access page, click on the part of the process they need, and it loads in a browser. I can link the whole document, but when i try to link to the bookmark I have created in...

Hi Access novice here, is there away to make a field only accept a date in a specific format ie yyyy-mm-dd hh:mm:ss. If a date is put in incorrectly say 2008-02-14 :23:59:9 then I would want an error to pop up and to disalow that date being entered Thanks

Ok Im having trouble with this, I need to remove cities from an address field but don't know a simple query that does this. Can any body help heres an example Address1 City 10/F, HONG KONG LAI CHI KOK EXCHANGE II HONG KONG Now I...

Hi Im really new to VBA and forms, and I need some help creating a form that deletes out all the data from two tables. Each fortnight I have to fill these two tables with thousands of records, I then have to delete out all the data. Is there any way I can create a tool that I just choose the...

Hello, My last quey was answered superbly, however I now need to know what I should do to find a word all in upper case in a field. E.g. Daves hardware inc Daves hardware inc Daves hardware inc DAVES HARDWARE INC Daves hardware inc Daves hardware inc Daves hardware inc Daves hardware inc JOS...

hello if any one can help me create a query that pick out lower case characters from the beggining of words, and the beggining of each word in a sentance , my christmas would be made! Thanks in advance

hello if any one can help me create a query that pick out lower case characters from the beggining of words, and the beggining of each word in a sentance , my christmas would be made! Thanks in advance