Search results

  1. T

    3 Page Form

    Hello, I have a 3 page form that is a copy of one of our Word document. When I do a print preview: On page 1, some of the data are being cut-off On page 2, half of the data are being repeated in page 3 Therefore, the beginning of page 3 is in the middle of the page Frustrated
  2. T

    Rerunning a script within Access

    Hello! This may sound an over-kill but hoping it could be done via VB code. I have fields in my tables that are being referenced into many of our Word documents. I need to find a script within Access that would open the file(s), refreshes, saves and closes. Would mean that for the future I...
  3. T

    Compile Error / Variable not Defined

    Hello! Help! Can anyone figure out what's the error in this code. I get a compile error/variable not defined and to be specific, points to this line of code. The NameToSearch turns black. ' Search for the name that the user entered. For RecNum = 1 To LastRecord Get #FileNum, RecNum, TmpPerson...
  4. T

    Compile Error

    Hello! I have a form that has a text box and when you double click on the text box, download will happen automatically from textfile but instead I keep getting a compile error / syntax error. Can anybody figure out what is the syntax error in this code?. The line "On Error GoTo readAllFile...
  5. T

    Error 3058

    Hello! I have 2 forms frmSource and frmDestination. On frmSource I also have a textbox called AssyPartnumberVis which are concatenation of values from 3 listboxes. This the code in the control source of txtAssyPartnumberVis: ="A" & [lbxCuttingTools].[Column](0) &...
  6. T

    Input Mask

    Help anybody! I have 2 forms: frmSource (data came from 5 tables and consist of textboxes, comboboxes, listboxes, etc.) and frmDestination. I would like to add another field in the Destination table called AssemblyPartnumber. The system requires that we generate a unique partnumber Example...
  7. T

    Changing primary key

    Help anybody! I have 2 forms: frmSource (data came from 5 tables) and frmDestination. Question: frmDestination is setup to have an ID field (is that necessary?) Is this possible to replace ID field to become Assembly Partnumber instead? For every record collected from frmSource will be...
  8. T

    Script

    Hi Can anyone suggest a Website that could give me some information about writing a Script or books that I could research? Thanks
  9. T

    Script?

    I'm not even sure if I will get any response to this question, but I shall give it a try anyway. I have this huge database that consist of various tooling (ie: drills, inserts collets, etc)in Access 97. I wanted to dynamically incorporate changes to various procedures in Word format that...
  10. T

    3 Option buttons with 1 list box?

    Help! This is a litle complicated. I have 1 table: Field1=MachineID(3 types of machine); Field2=Function(5 types of function);Field3=MachineHolder(5 types of MachineHolder). All 5 types of Function are being used in all 3 types of machine. The only thing unique is the MachineHolder. Using 3...
  11. T

    Passing the value to 3 fields based on the selection in a combo box?

    Help anyone before I lose my hair. 1 combo box with 5 values to choose from. These 5 values consist of 5 groups of functions. Based on the function selected on this combo box,how can i automatically fill in the values in 3 other fields? I tried to make 5 different forms but how do I tell...
Back
Top Bottom