Search results

solved - Locking text boxes Hi guys, I have a form that is opened when a user presses a button. Once the new form is opened a unique ID is passed across a put into a text box (which is invisible). The user then inputs some data and hits the enter button to assign the data to the person...

Hi guys, Another one for you whists I'm learning the art of access :-) I have a report thats doing a grouping by clientID, with the detail for each client showing hours worked and a total amount for that time period. In the clientID footer I have a line that just prints on the page and...

A stupid question here... I have a form that has a single bound text box that is set to currency. The table is also set as currency with decimal places set at 2. I have my own save button Now I want to catch if the user types in text instead of numers and display a suitable error message...

Hi guys, I has a subform in datasheet view. Now when this is loaded I always want to be at the last record in the subform. I've searched through the forum and am completely unsure of how to do this... Any hints or tips appreciated :-) Cheers

Hi guys, I'm obviously doing something stupid in my form :-) If you open the form in the attached sample you will see that I have 2 combo boxes. One of them has a default value showing and the other doesnt, I want to get the second combo to automatically show the value in the list but just cant...

Obviously doing something stupid here :-) I use a form for data entry. When I hit the next arrow in the navigation button section (the default navigation buttons supplied by access), by data is saved into the relevant table. When the I press the X on the form my data is also saved. However I'm...

Hi guys, I have a form that the user uses to input data. If the user tries to close the form by clicking on the X then a warning message is displayed such as: The field cannot contain a Null value because the required property for this field is set to true. Enter a value in the field. What I...

I'm running a query that pull all records for a specified month. The report that I'm creating groups this information on a lastName basis, and for each lastName a group is set up on a weekly basis (this grouping obviously being on the date field in the query) Now for each week I want to...

Thought I had understood getting fields from linked tables to display correctly in forms but what I have now is not working.... :-( If you open the attached db and then run the frm 'frmEnterTimeSheets' you will be presented with a text box asking for a name. Type in Alldridge and click the add...

Hi guys, I'm trying to create a simlpe database that is use to store time worked for clients (see attached). If you run the form frmClientEntry i have two issues. 1 - you will see that the title is automatically selected from the combo box. However is i try and enter the form I'm told 'You...

Hi guys, Attached is a real simple database. What I want to be able to do is insert new payment details, and I have a couple of issues. I have two clients and need to be able to select which client I want, select the payment details from the drop down list and enter in some appropriate amount...

I have developed an db on my local machine, and part of this automatically sends out emails. As this is local then the senders email is obviously mine. My boss has mentioned that he would like me to make this DB accessible to a few users. Now I know that I can split my DB to FE and BE but what...

I've got a form that has some code behind it that queries databases / updates and sends out email. This all works nicely... However at the moment the user makes a selection in the switchboard to show this form. They then have to click on the 'go' button to get the code behind the form to work...

Hi guys I'm having issues with getting UK dates to show in access. I created a table and then undertook an insert with the following: docmd.RunSQL "INSERT into tbl_test([dates]) VALUES (#01/06/2005#);" Note that my machine is in UK local and the format of the field is short date. The date...

Hi guys, I'm using the following code to pull info from messages in outlook. strContents = msg.Body splitstr = Split(strContents, vbCrLf) Dim strDate As String On Error GoTo errorhandle 'get date of download strDate = Trim(Mid(splitstr(4), 8)) If (Not...

Hi guys I want to be able to run a query via VBA to pull out all records according to a criteria ie select product where email=xyz.com Can anybody tell what the function is called that allows me to do this. Been hunting for some time and have only come across the aggregate functions ie...

Hi guys I want to be able to run a select query such as: select distinct email_address from tbl_download where email_addres='fred@xyz.com' in VBA code in access. I then want to be able to see if my result set contains any info ie there way an email address. If yes I will do one thing, if no...

Hi guys I'm writing an app that does a recursive search from a top level folder looking for unread emails. I then pull out the info from the msg.Body and put this into access. However I've yet to find a way of alterting the state of the msg from unread to read. Any ideas what to do?? Heres...

Hi guys, I've got a form that shows the result of a query in datasheet mode. However if I use a switchboard to open the form (and hence run the query) the results aren't in datasheet mode but in column mode. How do I get the this query to display in datsheet view? Thanks