Search results

any chance you could help me with my problem? people are looking but not actually helping, this si the third time I hace used this forum and got nothing from it

I can't believe 39 people have viewed this and not one person can help!!!

can any body help?

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...

Brilliant, thanks for that. Stupid question really!

Ok but how do I make it only accept date values of yyyy-mm-dd hh:mm:ss?

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

there is an easier way left([fieldname],instr(1,[fieldname],"/")-1) Put that into the update row, or create it as a new expression just to check first

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...

Hi I copied and pasted it into sql, and renamed the values where needed. however I got an error saying undefined function fstringcomp what am I doing wrong, my sql looks like this SELECT IIf(IsNull([FST_NAME]),False,fstringcomp([FST_NAME])) AS expr1 FROM Siebel_mkt_contact_12012006_EMILE_HAS...

ok once I have ticked that box, how do I do a comparison? also how do I expand this quey so I can bring back a sentence with all lower case characters IIf(IsNull([YourTableFieldNameGoesHere]),1,Asc(Left([YourTableFieldNameGoesHereAlso],1))) eg dog house rock Dog house Rock dog House rock...

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...

aha you absolute beauty i was just about to post the sql and ran it again and it worked fine!! I could kiss you now if I want to do that but for various words such as ,"Systems engineer cisco" How would you pull the last two words out of the field does this make sense?

same thins happens, now if i take the criteria out, it works fine and gives me the ASCII value

Ok tried that last post and I still get the same error,'data type missmatch' the query then spits out just the value #name?

that's just a typo, I still get the error

the code that is mentioned above ASCleft([fieldname],2))>97<***