Search results for query: *

I need to write a large if statement checking which items have focus. How do i check if an item has focus? If Me!Page4.?????? Then blah blah Thanks.

I have built my wizard interface (using the tab control)for completing a form. The wizard form is called when a new record is created, the wizard guides users through test proceedures and provides fields for the results to be entered. These results are then transferred into a results form (once...

I am creating a wizard interface for completing a form, does anyone know the vb code to show the next tab when clicking on a cmd button? So I can have Next and Prev buttons. Thanks.

Access 2000 has error with the following code: Private Sub Form_Open(Cancel As Integer) Forms!hyperlink_builder!txtname = Left(Forms!AddRecord!RaisedBy, 3) Me!txtname = UCase(Me!txtname) Forms!hyperlink_builder!txtdate = Format(Forms!AddRecord!DateRaised, "ddmmyy") End Sub I'm sure...

I would like a reminder to appear when a new record has been added to the database. The reminder needs to prompt the user if they wish transfer some files (a seperate form performs this function). Any ideas?

I have a parameters table (which holds the paths of several folders on a server). I have added text boxes to the form and I can edit the folder paths. I would like a user to be able to click a button and launch a save/save as style wizard that the user could use to find the folder and then the...

I would like a button that a user can click on my form, that when clicked copies files from one directory on the network to another. Is this possible and if so how?

Hi, I have two images and would like one displayed depending on whether the textbox 'customer_name' is empty and the other image if the text box has data in, what's the vb code for this???? Thanks.

I have a form a user completes and I want to use some of the information in another form that is open at the same time. I need to take the first 3 letters of the first name and insert them into my second form. I also need the date which is currently in DD/MM/YYYY to be inserted into the second...

Hi, I have 2 text boxes and a combo boxe that are used to create a hyperlink to various files on a server. All the file names are ina similar format DDMMYY_XXX_X, Each combo box deals with a section ie. textbox 1 deals with the date, text box 2 the initials and the combo box deals with the...

I would like my text field (txtcustname) to suggest a customer name as the user types it in, just like in Excel. Is this possible and if so how?

I have a form with a subform. The main form has 3 list boxes on. For the on click proceedure for each listbox I have the following code: Dim CustFilter As String CustFilter = customername_filter searchresults.Form.Filter = CustFilter searchresults.Form.FilterOn = True Nothing happens when I...

I have a list box which currently displays the returned product from a table. The problem is there's a lot of repeat enteries ie 10 of the same product has been returned, how can I limit it to one entery per product type?

Hi I have a form that has several search criteria text fields on it, when some fields are blank the query fails to work even though I have used IIF statements in the query for fields that could possibly be blank. Here is a copy of the query from sql view: SELECT TRACKER.RecordID...

Hi, Could someone show me some example code I could use to prompt the user to save or disgard the information entered into the form, when they exit the form? Thanks.

I have a form users add a new record to. It also has a print button which allows the users to print the current form in a report format. The problem lies when a user has added a record but not closed the form (and therefore the record has not been added to the database) the report then prints...

Hi, I have a search form that has a text field (txtsearchcriteria), and two drop down boxes (cbosearchwhat) and (cbostatus). cbosearchwhat has the following options date, name, company. cbostatus has all, closed and open What I would like to do is have one SQL statement that processes the...

Hi, I am trying to create a field on a form that allows users to browse for a file and once the file has been seelected a hyperlink is created in the field allowing users to view the linked file. Could someone help me please!

Hi, I'm completely new to this ASP/Database interaction. I have previous experince with HTML/Javascript, I have also developed a few databases and understand queries. I have created an access database with a table that contains the fields I require. I would liek users to be able to search...

Hi, Can anyone tell me the Vb code to close a form without saving any of the data a user my have inputted? Thanks, Ian.