Search results for query: *

I have a form with 2 subforms MainFrm Subfrm1 used as a tool bar with several buttons subfrm2 datasheet In subfrm1 I have a Toggle button, when i click it, I want subfrm2 to display all records and with another Toggle button I want to display only records where datefield has no date . Hope...

I have a Main form(Table1) with a subform (Table2) Table1 has a field named Counter(number) The subform has a hyperlink field (Link) that store's the path to files on the server if i have 3 hyperlink record in the subform I want to have the total of 3 showing in the Mainform's Counter field Can...

On a form I have a button named NCR and a check box named "View" On opening the form if the checkbox "View" is equal to -1 then button "NCR" is visible if = 0 then not visible How do I write this code up what I have so far is not working Private Sub Form_Open(Cancel As Integer) If View = -1...

as soon as I add more that 42 records to a table and try to open the table it freezes I can view it with forms but not open the table Has anyone got any ideas on this

I have a control button with the following code It opens a browse window where you search for the file and then it places the path into the field called filepath ( Hyperlink type field) but when I click the path in the field it does not link Please help Private Sub Command7_Click() Dim...

I am very new to Crystal reports and I creted a rpt based on an MS SQL table and the date field "TDATE" 25/08/2011 appears as a number on the report e.g. 20,110,825.00 I have created a formula that converts it into a date I got this formula from this site and it returns the number as a date on...

Worksheet 1 is populate from another source. with 4 columns, No of rows vary each time populated ID Date Job Number Hours 1 1/01/2011 1000 5 2 2/01/2011 1000 3 3 3/01/2011 2000 13 4 5/02/2011 3000 7 On worksheet 2 I have added formula to select only Date, Job Number and Hours, colums e.g...

I have a Table "PivotChart" populated with data for Pivot Charts The Pivot chart will be based on the jobno field Catagory fields in Pivot cart will be jobno, ScopeDescription.PercentDescription Data Fields in Chart will be Budget,Hrs,PercentAsHrs, I wish to display a chart for the first Job...

I am trying to do a simple update query based on records match between 2 tables but when i run the qry I get the error nessage "The search key was not found in any record" UPDATE [labour detail admin copy] INNER JOIN [Temp tbl] ON [labour detail admin copy].LD_ID = [Temp tbl].[ID Number]...

I need to write a query to filter records that were created in the previous week, can you please help me with this one, Thanks in advance Each record has an OpenDate field.

I have connected to a database tables using ODBC but dates are stored as a number eg 20081024 I need to ceiw this in forms or reports as 24/10/2008 Can anyone help me with a fis on this Thanks in advance

I am importing data from a comma delimited text file the supplier invoice number is a text field. I am using Transfer text in a macro to do this some of the invoice numbers are e.g. 0008744, 08899, ab234 etc. when it is imported into the database table , into a text field it drops the zero's...

I have a button on a form that will send an access report to the address in the field "email" if there is no email address I want it to send the report to the printer this is the code I am using behind the button. DoCmd.SendObject acReport, "WorkOrder Loco", "SnapshotFormat(*.snp)", [Email]...

I have a combo box which will show a list of cost codes e.g. 5-1420 but I find users are able to over type the data to something else e.g 51420 How can I stop a user from entering anything but whats in the lookup table that stores the cost codes. Thanks in advance

I have a button on a for with the following code in the click event Dim strPath As String strPath = Me.TxtFilePath Application.FollowHyperlink strPath, , True, False This works fine - Opens a document ( doc, PDF xls ) that is in the TxtFilePath field. Instead of opening it can I just print...

I have 4 field ID, Supplier, Qty, Item I want to output the data to a text file ( comma or Tab seperated) I want the output to keep the same Id numbers together with linefeed between each group eg. 1 blackwood 3 drill bits 1 blackwood 5 spanners 1 blackwood 20 pins 2 universal 10...

I have a table with about 1000 contact names and details The PhoneMo field has numbers eneterd as 0812345678 I want to alter the data so that it reads 08 1234 5678 Is this possible Thanks in advance

I have a form(Table1) with a subfrm(Table2) Link by ID in each table The main form generates the Purchase Order number - ID ( autonumber) And Suppliers Name etc. The sub form( tabular frm) contains LineNo, Qty, description and price. (LineNo is a number field) I want the line number to start at...

I have a table with 3 fields ClockNumber Date Shift Clocknumber and Date were both Primary keys to stop a user enetring the same combination of data twice This has been working great for several months A user came to me this morning and told me that they had entered the same clock number and...

I have 2 fields in a form start date End date when the form is open i wish to have those fields automaticaly populated with the first and last day of the current month Please - How do i get this result. Thanks in advance