Search results for query: *

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...

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?

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.

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...

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...

Thank you very much, this will work great.

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

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...

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.

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.

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...

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.

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...

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.

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

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))?

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

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...

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

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)...