Search results

first thank you all and i'm sorry I mixed up the question the first code is on the end user db. a worker login and its automtic print is daily job the second code is in my office on the main db. the code print the report and marked the field yes/no to yes to know what jobs was printed now...

i wish but it's complicated each code is in a different db i have to combine the 2 code to one code that will execute when the user log in

i have 1 code for login and print a daily job for employed Dim rs As Recordset Set rs=CurrentDb.OpenRecordset("tblimployd",dbOpenSnapshot,dbReadOnly) rs.FindFirst "username='" & Me.txtusername & "'" If rs.NoMatch Then Me.lblWrongUser.Visible = True...

i hope this will help you http://www.vbaexpress.com/kb/getarticle.php?kb_id=813

work great thank you

i have a report that i have to print and then marked this report with yes\no field that the record has been printed but my db stack (infinity loop I guess) my code Private Sub btn334_Click() DoCmd.PrintOut PrintRange:=acPrintAll, PrintQuality:=acHigh, CollateCopies:=True Dim rst As Recordset...

you are using building library that as it's on dialog so no properties in the code try making the scanner the default in windows

didn't got you where is the txtlastday or i have to create a form with txtlastday or... or... thank you

header in word insert manually try this code DoCmd.OutputTo ObjectType:=("tablename")AcOutputObjectType, ObjectName:=, OutputFormat:=acFormatRTF, OutputQuality:=acExportQualityPrint, =acPageHeader

hi: i have a reports that every employed go to a end user pc enter his name and password and click print. it well print the jobs he have to do my Q' is how do i set the report to print only the new records that created after the last print (i have a field for record insert date+time)

on each field you have a criteria put there ="your combobox name"

make a query from the subform that the report get the value from it. in the field put ="what you put in the combobox"

Dim dioGetDependencyInfo As DependencyInfo Set dioGetDependencyInfo = aob.GetDependencyInfo

you need to make a report for the subform then add a button in the form design view. chose the name of the report this is a macro not vba

not sensitive like army or benk just a student details pls pls stop Q' i need answer :)

i use linked table so the dont have the link to the second table

cant one table is for end user and in the second table i'm attaching sensitive material

i have 2 table that have the same fields the have autonumber index without duplicate how can i make tbl1 to check what is the last number in tbl2 and give the record in tbl1 a number that is not in tbl2 i have append query and i can't run it because duplicate error

for now the system must keep working so i need a vba code in the future i well build it from scratch

thank you all i didn't build this db i got it to fix and add things. the db is already working for a long time so i don't want to get into it my code so far Private Sub btn75_Click() Dim rs As DAO.Recordset Dim db As Database Set db = CurrentDb Set rs = db.OpenRecordset("students") With...