Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. alrandal

    Select Radio buttons to print report

    Ok ive got it working now here is what I used: Private Sub print_Click() Dim strSQL As String 'Create the Where Clause for printing selected records strSQL = "printcheck = True" DoCmd.OpenReport "CustomerIssues", acViewPreview, , strSQL strSQL = "UPDATE...
  2. alrandal

    Select Radio buttons to print report

    Is still asking for a parameter value, my check box is bound to a yes/no fiels in the record source, I also put the same checkbox on the report bound to the same yes/no field in the table, I turned filter on and in filter I put printcheck = true can you tell whats wrong?
  3. alrandal

    Select Radio buttons to print report

    No thats not going to work because it askes for a parameter value, I dont want them to have to enter a value, I want it to know that the check box is set to true, and thats the only value it will need to print. I appreciate all the help.
  4. alrandal

    Select Radio buttons to print report

    Oh ok, Ive got a report already, all I need is the code that says if this check box is checked then print just this record in the report, right now I have like 50 records in the report, but when a user wants to print just one, they cant, they have to print the entire 50, thats not what I want, I...
  5. alrandal

    Select Radio buttons to print report

    yes, thats how its set, I will use a check box or radio button, it doesnt matter as long as it changes to yes/no or true/false, as long as it will tell the code print or dont print. I would like something as follows. If Me.checkbox = True Then DoCmd.printReport "ReportName" End If...
  6. alrandal

    Password Protect

    Thank you very much, this will work great.
  7. alrandal

    Select Radio buttons to print report

    Thats what I have now, I have a yes/no field on my table called print, if its checked then print the report if not the dont, Im just not sure how to code this to work properly. Thanks for the help
  8. alrandal

    Select Radio buttons to print report

    I would like to have a form, that has radio butoons next to a record and if my user wants to print the report for that one record they would select the radio button and then print, or if they have 5 out of 10 records they would like to print they would select each radio button and it would only...
  9. alrandal

    Password Protect

    I would like to be able to password protect my entire database, I would like one password that allows admin privlages and one that only allows user privlages, I would like to do this with a splash screen, I do not want to use the security wizard. Any help would be appreciated.
  10. alrandal

    From Excel Chart to Word Graphic

    Hey muki, Ive been having the same problem as you. I have an Access form that im trying to get to loop through excel and grab the graph and paste it into word. Could you help me with what you have so far.
  11. alrandal

    Dumb Question: Can I use VB 6 to program MS Access?

    VBA and VB6 are not much different, but they are different. Yes access is written in VBA, as is Word and Excel. By using VBA you can access excel and word from the Access database. I created an Access Database that is filled in by the user and then they click a button and it fills in a word...
  12. alrandal

    Dumb Question: Can I use VB 6 to program MS Access?

    I am a office developer and all the office products are written in Visual Basic for Applications(VBA) code, and you dont want to write anything in VB6 and try to convert it to an Access database, that makes things more complicated. Just use the modules within the Access database to write your code.
  13. alrandal

    Sort Data by numbers

    Ok this is what Ive got so far: Private Sub btnGetNewNumber_Click() Dim i As Integer, N As Integer, Nfound As Boolean N = Val(List0.List(0)) Nfound = False i = 1 Do While i <= UBound(List0.List) And Not Nfound If Val(List0.List(i)) - N > 1 Then N = N + 1...
  14. alrandal

    Sort Data by numbers

    the errors are on &quot;.list&quot; Err= &quot;Data member not found&quot; and on &quot;i<ubound&quot; I get Err= &quot;expected erray&quot; this is after I change the code to match my form.
  15. alrandal

    Sort Data by numbers

    the errors are on .list Err=Data member not found and on ubound I get Err= expected erray
  16. alrandal

    Sort Data by numbers

    ok Im getting some errors and I ve got some questions, I changed &quot;lstNumbers&quot; to the name of my list, but what is the rest of the code .list(0)) and .list(i))?
  17. alrandal

    Sort Data by numbers

    &quot;lstNumbers&quot; what does this variable represent? Is that referencing the list box?
  18. alrandal

    Sort Data by numbers

    ok Ive got a table full of 10 digit numbers &quot;111-2222-333&quot; I have all these numbers in a list box on my main form, so the user can choose. Lets say the user wants to enter new data with a new number, but there are hundreds of these numbers and they dont want to have to scroll through...
  19. alrandal

    Loop through Excel, Paste into Word

    Could anybody give me some examples of code to loop through an existing Excel spreadsheet, pull graphs from diffrent pages in that spreadsheet and then pull data from cells and paste them into an existing word.dot template using bookmarks on the word.dot
  20. alrandal

    Using Automation

    Ok Brian I did what you said and I saved the Word.doc as a .dot file and I used this code: stESSPPath = &quot;\\Path&quot; stSaveFileName = (CStr(Forms!FrmDocCreator!txtESSP) & (CStr(Forms!FrmDocCreator!txtRev))) objWord.ActiveDocument.SaveAs stESSPPath & (stSaveFileName)...

Part and Inventory Search

Back
Top