Search results

Hi Pat, Yes the Developer's Edition. Been watching too many Star Treks!!! Matt

Thanks Kev. Matt

Have Microsoft released the Enterprise version of Access in 2003? If yes then Need to find a UK disty that supplies else return to drawing board end if Thanks Matt

Thankyou for your help. Much appreciated. Matt

Hi Just tried your suggestion and get the following output: 0.515266203703704 For a TimeStamp of 13:21:59 and a selected value 0f 00:01:00 Just read up on the CDate function, does this only apply to dates rather than time, or is this a silly question? Matt

Hi, Is it possible to do the following in a query. I have one field which when a record is created stamps the time in the following format ##:##:## The field is called [TimeStamp] I have a user combo box which has a list of the following values: 00:05:00 00:10:00 00:15:00 00:30:00 etc etc...

Hi Guys, Thanks for the tips. dcx693 you are right about not normally case sensistive as i have many other queries where this does not become a problem. The only thing that i can think of is the data is linked to a csv file, this is the only thing different to all of my other queries. (100's...

Hi, I am using the following in a query to filter out records from a csv linked file: Like '*' & [Forms]![frmIfrComponentsMainScreen]![SearchByComponent] & '*' This works just fine to a point, it seems to be case sensitive, how can i make it not case sensistive? I am sure i have overcome...

Hi TDM, Thankyou for your time on this. The security issues in Outlook have always has been a concern for me and so i have patched it up to the hilt to try and minimise this concern. The system that i have written/designed here needs to send an email out once a week. The email must be...

Hi all, Can Access support emailing without using Outlook as the program to send e-mail? Can it communicate with an external email server directly? Ohhh all of these questions and soooooo much to do!!!!! :rolleyes: Matt

Hi all, Havent been here for a while. I am trying to pad out a number so that it always displays 8 digits and starts from the right ie 00000315 00000316 etc, etc i am using the following as it is a barcode in a control source field: ="*" & "00000000" & [UnitSN] & "*" At the moment this...

Thanks guys, for your inputs, both answers seem to work fine. Matt

I have been trying to solve a date criteria problem but to no avail. I have been asked to set the criteria of a query so that the data result set is +45 days from Now() and from that point one months worth of data. Basically trying to create a forward date window which is 45 days ahead and...

This is a really strange problem which i think is only Access related: Our database is setup for multi user and has been working fine. I added a new user who is based not on the site where the db resides but is able to login into our Terminal Server and access the db, this worked fine until...

I have the following code which works fine on a button. stLinkCriteria = "[Top Level Assy No] Like '" & Me![SearchTxt] & "*'" What i would like to do is to get the search to search a text box on a subform which resides on the mainform where the "Top Level Assy No" is as well as doing the "Top...

Thats the one, thanks Rich.

Hi Rich, I want to place some vba into a frame so when a particular option is selected the page will become enabled, if not the page stays disabled. Matt

How do you reference a Page in a tab control in an expression. Say i had a form thats called "myForm", a tab control called "myTab" and a page on that tab control called (hey you guessed it) "myPage" Would the reffering expresion read as follows: Forms![myForm]![myTab]![Page:myPage] or...

Thanks for your reply doc_man Will have a look at these posts. cheers Matt

Hi all, I have a form which is set to continous mode. On each column i am placing a combo box to allow filtering of the data that is displayed on the form. I have used the following VBA to get the first combo box working; DoCmd.ApplyFilter , "MANUFACTURER =...