Search results for query: *

I have a quick program to record payroll information and print the cheques, is there a way to convert or display a number as text (say $1245 displayed as "one thousand, two hundred forty five"?)

I have 3 tables with about 40 Yes/No fields in each - the client would like a seperate option button for yes and no so the user has to select one or the other, I know I can do this by making option groups but doing the wizard 120 times is going to take a while, is there a faster way I can get...

I have an microsoft access DB that I created and was working fine. I tried to split the database into two using the database splitter and gets error "error accessing file. network connection may have been lost". So I re-attached the tables back to front end and still get the error. I open a...

I have an microsoft access DB that I created and was working fine. I tried to split the database into two using the database splitter and gets error "error accessing file. network connection may have been lost". So I re-attached the tables back to front end and still get the error. I open a...

A client of mine had an employee that created a Microsoft Database. if you hold the shift key down and open the DB no forms or tables appear so you cant see the data/forms/etc. is there a way to bipass this? I dont condone hacking but the data belongs to them not the (now terminated)...

Im trying to copy a file from one location to another on a click of a button. Im running access 2000. I have tried using the following code Dim fs As New Scripting.FileSystemObject Set fs = New FileSystemObject strFilter = ahtAddFilterItem(strFilter, "CAD DWG (*.DWG)", "*.DWG")...

I seem to have a bit of a problem. I am running ms access 2000 and I need to offer a way for the client to browse for a file and store the path into a field in a table. I have searched Tek-Tips and have found the following. I dont seem to have the active X for the common dialoge box and the...

I have a button on a form that runs the code Application.FollowHyperlink me.UL_Link.Value and I receive the error "run-time error'5': Cannot locate the Internet Server or Proxy Server. any ideas?

pretty straight forward question I have a listbox on a form. the form is unbound and the listbox has a rowsource set to a populated table and is showing the data fine. I want to create a command button on the form that when pressed will select all items in the list box so the user doesnt have...

I have a form whith a subform. on the subform there are three fields of inportance: qty : a text field-numeric value that lists the quantity ItemId : a combo box with three columns (ID;Name;Value) txtCalculated : a text field with controlsource of =([Qty]*ItemID.column(2)) I want to have a...

I have a continuous form that is bound to the table. three fields in question at the moment: cboCategoryID - a combo box bound to field catID txtEmployeeID - a text box bound to field EmpID and is hidden txtStartDate - a text box bound to field startdate the textbox is set to have the...

I have a form that opens to a new record. the ID field sits stating autonumber (of course) now all of the controls on the form are bound and have default values entered and 97% of the time dont need to be changed. There is a subform on this form where most of the data needs to be entered...

I have a form with a multi select listbox that lists employee (2 columns-first is empid second is employee name). I need to build a query from the listbox itemselected field so just the selected employees are shown in the report. any ideas how to start?

I have an mdb and I have set the startup option to load frmsplash. on the form load of frmsplash I call a public Sub that checks a few tables to verify that there is data in them. IF data doesnt exsist a text box is filled with text, three buttons are shown on the form and it ends there until...

I am trying to build a form that creates a command button for each employee in a table this is what I have so far. Public Sub LoadMenu() On Error GoTo Err_frmLoad_Click 'create a command button for each active employee listing 5 per row\ 'that will open entry form and set the default employee...

I have a database that I have to determine if an employee worked overtime in a week, I have a table that records the date the employee worked and how many hours worked. I want to determine the number of each date in a seperate field. is there not a built in function that will tell you what week...

I have a form in Outlook 2003 that has an IIF statement as the control source. I need a way to refresh the form so Outlook will refresh and re run the IIF statement any ideas?

I have a form that I almost need a grid or excell style data entry. its a form to enter employee hours against work stations. (how many hours on this date did this employee work at this station) to make it easy for users to enter an employees time sheet what would be ideal is all stations...

when creating a distribution list in outlook 2003 it displays the fields NAME and Email ADDRESS. any way to add Company Name/Fax/ETC

is there a way to set the values of the fields on the find and replace window? i.e the LookIn combobox or the Find text field?