Search results

Hi I found below code on another site that does most of what I need it to do except for a few things I would like to add if possible. The code splits all sentence's in column A into maximum character length of 40 whole words in each sentence. Currently the split 40 character chunks are...

Hi I would like to Increment a line item number by 0.1 depending on value in a particular field. The Field in question will have a "S" or an "N" When its an "N" I would like the preceding number to be incremented by 0.1 E.g Item No Code 1 S 2...

Hi Is there any way of Copying multiple cell selections from Excel to be pasted into another program. (Like an ERP system data entry screen) The cells to be copied may not be equal Eg. A1 to A5 A2 to A13 A2 to A7 etc The data then needs to be pasted in running order with no spaces between the...

Hi I have a continuous form and one of the feilds is a checkbox. What I would like to do is have a command button which when I click it all the checkbox's which have a check in them to be deleted. Can anyone please help me with how I could do this. Tks Roc

I have a checkbox on a subform XYZ that when checked i would like the Value in Feild A of this subform to appear in Feild B in a second subform ABC. I think I need an after Update event but not sure of the code to use. Can someone please steer me in the right direction. Tks

Hi, I have a TransferSpreadsheet Macro where I import a spreadsheet on click of a command botton. The settings are Transfer Type: Import Spreadsheet Type: MS Excel 5-7 Table Name: XYZ File Name: C\Documents and Settings\Home\MyDocuments\XYZ.xls Has Feild Names: Yes Range: (nothing) Is there...

Hi, I have a continuous form as a subform on a main form with one of the feilds being a checkbox. Once this checbox is ticked I would like todays date to populate a new line in the subform. Can anyone please help Tks

Hi I have a form which records calibration data on equipment & when it is due. In the form I have a field called calibration Intervals with a figure in months when calibration is due for each equipment item. E.g. 12 months. I have a subform on this form which records all the calibration details...

Hi, I am starting to design a Quoting database and would like some advice on how to set up my tables. I would like to record all quotes received with all relating sales, purchasing and despatch/invoice details included. I am thinking of having following tables – Am I on the right track ...

Hi, I have an IF formular which looks at a feild & if it is greater than Zero multiplies the value by 10% but if it is zero (no value) I would like the feild to be blank or a Zero to appear. =IF(F38>0,F38*0.1,"0") My formular is giving me a #Value! error when value is zero. What am I doing wrong...

Hope someone can help with this. I have a form which lists all my outstanding orders. Via a Dcount I get a figure of whats in stock for each order (product description & length) & this figure is listed against each parrticular order.(stock Qty) But what I also want it to do is look at the Qty...

Hope someone can help me with this as I am not sure where I am going wrong. I have two combo box's on a form which are linked to a query which when run SHOULD (this is my problem) populate a subform I have set up on same form. If I run suborm or query on its own it works OK but I cannot get it...

I have a query with below formular which return's all records between Sunday and Saturday Between Date()-Weekday(Date())+1 And Date()-Weekday(Date())+7 I can get this formular to work when it is looking at one date feild. (Date Received). I would also like it to look at the (date completed)...

Hi, can anyone advise where I am going wrong with attached query. I just want the waiting time between two sets of time but I don't seem to be able to get the right figures. I have tried to change the property of the query variable by going into the feild properties for the calculated feild but...

Hi I am looking for a formula for my query which filters out only the orders raised in the current week.(5day week Monday to Friday) I did not want to enter dates manualy. Can this be done ? Can anyone help me with this. Tks

Hi, I would like to insert the currrent time in a feild on my form once a checkbox is ticked. Can anyone please help me with this. Tks Rgds Roc

Hi, Can anyone advise why I am getting these two error messages in attached image. I am running Access 97. The first message refering to fDesign appears each time I have something open & click on the Design View icon. The only way I can go into design view for a form or table etc is when I...

Hi I have a calculated Field query which groupes all the different order types by the first char A, B, C, & D with the corresponding total sums for each order type. Now I would like to have a form which displays each order type & the corresponding sum value for each type via a text box. I am...

I have a main form with a few imbedded sub forms. Sometimes these is a great deal of data in one of the sub forms & non in the others. Is there a way that the sub forms can grow depending on the amount of data there is in each particular sub form. (The sub form grows for a lot of data & shrinks...

I have a popup calendar which works perfect on my form but will not work in an imbedded sub form. If I go to the sub form itself it works perfect both in datasheet view and Form view. But if I go to the main form which this same sub form is imbedded (datasheet view) it does not work. The...