Recent content by Presterman

Just adding it on works: ((TEST1.DATE_VALUE =#4/21/2005# +3));

Hi, Try this: FulllName: Right([Name],(Len([Name])-InStr([Name],","))) & " " & Left([Name],(InStr(1,[Name],",")-1))

If I was using Access the first thing I would do is to loop through all of your text files and collect the data into one file each record of which would perhaps look something like this: station3, Adobe Acrobat 5.0 station 3, Ahead Nero OEM station 4, Whatever Etc.. Make sure that there is a...

Hi, Don't know if this will be any help at all, but I use an Access database as a backend to my Perl. Large amounts of data like this are simpler to manipulate and examine in a database like Access. I can give you some code that will show you how to do this, if you like. If you just want to...

Try the DatePart() Function Dim TheDate As Date Dim Msg TheDate = InputBox("Enter a date:") Msg = "Hour: " & DatePart("h", TheDate) MsgBox Msg

Hi, As a bookmark is a binary string, it is quite possible it may appear as a square box symbol. Binary strings can contain non-printable characters. I am still wondering why you are writing a bookmark to a table? It seems to me you are trying to uniquely identify a record to lock. You could...

Hi, I don't know why you are saving a bookmark to a table. To quote from Access Help. 'Bookmarks are not saved with the records they represent and are only valid while the form is open. They are re-created by Microsoft Access each time a bound form is opened.' Bookmarks are really just...

I think you can cache password and id information locally when you connect through a wizard. Otherwise, you can set the connection properties programatically when the form loads. Here's a microsoft link which gives some information on this area...

I don't know if this will answer your question but... Make the source of your report a query which groups and counts your data. Use the totals button in the query design form.

You could use a randomly generated number..but the date/datetime solution is a standard one...

An idea: Have a list box where users can make multiple choices. This is not possible with a combo box (as far as I can remember). This is the best solution to this problem, I think.

The code you have should return a reference to a Shape object that represents the picture. Adjust the width of the Shape object (Shape.Width=x). This should give you what you want.

Hi, This probably has nothing to do with the registry. The code looks O.K. but check if txt_activity_id has a string value in it and that the length of the string that you are trying to input is not longer than the max length for the field you are trying to update. What sort of error...