Recent content by BSando

Hi, I want to call data from a table so I can manipulate the data. I am sure I need to use the openrecordset command. I can manipulate data how I want it, but can't work out how to call the field in the table. For example I have a table called "assetreport" and a field in the tabe is called...

JbinQLD Thank yu for your help this s just what I needed. Some people make things happen, some watch while things happen, and some wonder 'What happened?'

thanks. Looking at the Data again, the project name is always closed in brackets.Does that make it easier separating the data? Some people make things happen, some watch while things happen, and some wonder 'What happened?'

Hi, I want to split text from a table feild into 3 query fields for manipulation later. The text looks something like: 1234 southside project X 1324 South bank Project Y And \i want it to look something like this: Site ID site name project ---------------------------------- 1234...

Hi All, I want users to import an excel file to a table. I want the user to be able to select the file they import because every file will not have the same name. Everyfile will have the same format. I have tried the Transferspreadsheet cmd but i get an error because I don't have the file name...

Skip I found a work around. I just validated a cell instead of using the combobox and used Vlookup for the other cells that needs updating Thanks anyway Some people make things happen, some watch while things happen, and some wonder 'What happened?'

Hi I'm sure this is simple but I just can't get me head around it. I have a combobox on a spreadsheet which is linked to a cell (B9) and when the user selects the item from the list I want to update cells on the same sheet based on a table. I can update the cells with the below code...

Skip, Thanks for your help Some people make things happen, some watch while things happen, and some wonder 'What happened?'

Hi all I have a spreadsheet set up as a form where the user selects a site location and the other fields (i.e Address) auto populate based on a table I have on a back sheet. This works fine. But if the user needs to add a new site and details I want to have a user form where the data is entered...

I just wanted it to give the date the user fills in the form without updating it everytime it is opened Some people make things happen, some watch while things happen, and some wonder 'What happened?'

Hi All. Thank you for your help. For now I have gone with macropod's suggestion and just make it the current date. I did try to update the formfield by clicking on a label but that didn't work. Thanks again Some people make things happen, some watch while things happen, and some wonder 'What...

Hi All, I have a label in my word doco that I want the users to click on and this fills in a textfield with the date. It odes works with in reason, when I lock the form I get a message telling me it is a protected area of the document. what do I need to change so it works while the form is...

Fumei, my form as about 50 checkboxes on it. but I have broken those checkboxes up in to sections i.e. section 1 = area 1 of store, section 2 = area 2 of store etc. but I want to have a text field in each section on the form that tallies all of the checkboxes in that section. Some people...

Thanks. I tried to find the post, but I couldn't find it. I even looked under myThreads Some people make things happen, some watch while things happen, and some wonder 'What happened?'

Hi all, I have a word doco with checkboxes and thanks to help I have received I have been able count if the checkboxes are checked. But because I have about 50 check boxes on my form and my form is broken up into sections I want to be able to count the checkboxes by a range, so from checkbox1 -...