Search results

i didn't because i don't know how to point it to print multiple paths linked to every user automatically

Hello Guys, I've 2 tables Table for User Profile ( Name, Date of birth, address, phone, email,...etc ) and table named " Files " that saves file paths of ID Photo, Passport image, Certificates images ( i know its local file paths !) - All Files in PDF extention and report only showing user...

Db attached in zip already

It wont store this value in table !

So what to do in my case ? If what i need to do is against normalization rules ?

Sample zip attached i wanna copy the values from TimeDiff to ClockinLate in continues form and saved in table

Hi i've this Query as a record source of the form TimeDiff is the calculated field and now with the form as u see in VBAi wanna copy the values from TimeDiff to ClockinLate in continues form i tried to attach the sample DB but it's not allowed in attachment !!

already using a date source from the query and it shows what i want exactly in form all i want to replicate values from this field to table field

Hello Guys, I have a simple problem I guess :unsure: let's say I have a table with Names | TimeIn | TimeOut | WorkingHours Fields i've a form with a query in Record source, and I built a new field in a query to calculate the working hours with a name: Hours and I have a calculated field in...

that's what i see when compile

Thanks for the fast reply All Controls i wanna effect on it is Textbox and ComboBox only and after i put the updated code i got this error it appear on every textbox mouse move

Wow that's exactly what i want and I'm quoting the code here to ask a question and i hope you help me on it Function PassName() Function PassName() Dim ctl As Control For Each ctl In Forms!frmFormName.Controls If ctl.ControlType = acTextBox Then ctl.OnMouseMove = "=MyFunc(""" & ctl.Name &...

I just said that. I'm looking for the fastest way to just put a control on every report instead of editing evert report query

What post exactly?

Hello I have a form with many fields to fill and I'm using this code to make specific textbox to change border color on mouse hover Private Sub Detail_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) Me.txtUsername.BorderColor = 15197669 End Sub Private Sub...

Hello I have a table with an attachment field having a jpg image and I wanna retrieve it in a report like retrieving a text or number using lookup I can't use this table as the record source, it has to be same as using dlookup statment in the same report, i use this...

I've changed " to ' in VBA even in query criteria and it works now Like '*' & [Forms]![frm_Names]![FilterCat1] & '*' Thanks all

Hello I wanna change a record source of a form using VBA. Form Record source is SQL statement SELECT tbl_Names.ALC_ID, tbl_Names.ALC_Number, tbl_Names.OrderID, tbl_Names.Cat1 FROM tbl_Names WHERE (((tbl_Names.ALC_Number)=[Forms]![frm_Intro]![cboSession]) AND ((tbl_Names.Cat1) Like "*" &...

how to do it ? storing the font(s) in a table as a BLOB

Hello Good day to all, i'm using a custom fonts from windows in Forms and Reports and i wanna embed them to access front end instead of making a package and attach fonts files , i want it to go through access it self, like creating a table with fonts and attach fonts on the table and with a...