Search results

hello, I have a login form i want to use the dim function to put the userlogin in the dash board form i made Dim getuser As Integer getuser = [UserLogin.Value] DoCmd.OpenForm "DashBoard" Forms![DashBoard]!text5 = getuser i think there is a problem in the syntax of [UserLogin.Value] thank you

I tried the search before but may i didn't use the correct words. i will try the hyperlinks thanks

I made entry form and I have a column with an attachment type. I want to run scanner directly from the form. the available now is to scan the document to the PC then upload it as attachment to the database

Good,but I faced a new problem :( for the transaction number I made this Like [Forms]![Dash Board]![NavigationSubform]![CboTransNum] & "*" so when the combo box is blank it retrieve the all transaction the problem that when I request transaction number 1 it gives me 1 , 11, 12, 13, etc so i...

thank you it, working now Q: I have three parameters in the query to be filtered by the combo box the last one is the transaction date i could not make it like &"*" to avoid if the combo box is blank can you help me Between [Forms]![Dash Board]![NavigationSubform]![CboFromDate] And...

my form called : FrmOldTransaction it also in the navigation form : dash board the button : retrieve old transaction work in the form only not in the dash board it need me to enter the parameter

my problem is like in this post https://access-programmers.co.uk/forums/showthread.php?t=263872 i have tried the solution there but it is not working also

my form is "FrmOldTransaction" navigation form is "Dash board" original code : Like [Forms]![FrmOldTransaction]![CboPatientData] & "*" edited code: Like [Forms]![Dash Board]![FrmOldTransaction]![CboPatientData] & "*" also not working

i have used this code to view a message to confirm saving the case yes & no working well but the case cancel i need to make me remain in the same record without saving, but it work like cancel Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.Dirty = True Then If MsgBox("Do You Want To...

I have a form contain 4 combo boxes used to filter a query it all working well when I used this form as a sub form in a navigation form and try to run the query, access request the value of the parameter

I have tried this but not working in the close button . it also make saving Private Sub Command12_Click() DoCmd.Close acForm, Me.Name, acSaveNo End Sub

if you could help me , I will be thankful. I have two problem in the previous, and after search I solved one but this NO thank you:):) the problem in other words, I don't want access to save record from the entry form until the user press save. to avoid unintended saving when close or new.

access by default save all records immediately In the entry form the access save the entry always on closing or pressing new, I need saving to be after pressing save only

Ok I will do

thank you again you open the gate for me but i found another way. another problem, 1-In the entry form the access save the entry always on closing or pressing new, I need saving to be after pressing save only 2-I run some macros like delete records or append to a table, i want the...

OK I made a query to append the finished P.O. in another table to store all finished P.O. in it, but i need to give the P.O. a unique number to be as a P.O. number

thank you i got it, but i have more questions 1- the selection appears duplicates i.e. if the item is recorded more than one time it will appear during selection duplicated. 2- i need to clear the data of the supplier and manufacturer if i changed the item thank you again

Hello, this my first post here I have a source table with fields: item, manufacturer & supplier. every item have more than one manufacturer and more than one supplier. i have another table for purchase order, the same fields are available also, I made lookup for the field item from the source...