Recent content by Sweetu

you can use this also Dim SetTime As Integer, InfoBox As Object Set InfoBox = CreateObject("WScript.Shell") 'Set the message box to close after your desired seconds SetTime = 2 Select Case InfoBox.PopUp("Click OK (this window closes automatically after 2 seconds).", _...

which you want to make invisible set the visible property to false Private Sub Part_Number_2_AfterUpdate() If Me.Account_Ref = "ARB20" Then Dim answer As String answer = MsgBox("Do you need to enter another part number?", vbYesNo, "Another Part Number?") If...

make one combobox & add Ascending & Descending list, On After update Event paste this code If Me.YourComboboxName.Value = "Ascending" Then DoCmd.SetOrderBy " Primary kEy or your value for ASC" Else If Me.YourComboboxName.Value = "Descending" Then DoCmd.SetOrderBy "Primary kEy or...

in a separate table ?

Dears need a bit hint or assistance , What would be the structure for assigning case to another user & revert back to same and so on while keeping the track , such as jeorge created a case which saved in case table & case table have one FK with case to identify the user assigned, but how we...

Table or controls on form?

On create check out for code/module then copy/paste above code to VBE...name it and call however you need

Yes dear now you got it right...I need to set up DSN datasource connections.... I've to distribute this to 8 devices... Can you please teach me...how to do? Thanks for your reply though...

I checked everything is fine and indexed properly, just sql credentials is making me crazy...and searching via filter on to existed query takes 2 minutes... Before migrating to sql it filter out the records within seconds...:banghead: Someone suggested me to create ADO connection and add the...

I connected already via ODBC...but every time it requires sql login and password... Can you help me with ADO please?

Hi dears Experts! I need your help please... I've access 2013..which is connected to Sql 2008 via ODBC... Before I was using query for forms to filter required data... But after migrating tables from access to sql query takes much longer time to display in forms.... And every time I need to...

I'm using on load Form ,Still no success ------------------------------ If Is Null(me.textbox.value) then textbox.enabled=False Else textbox.enabled=True ------------------------------ but actually this should be on click button where I'll find in the form textbox for one...

Thank you dear for suggestions, the problem with page control is when we click on the page it goes slightly up and when we scroll via mouse wheel its not scrolling though scrolling part is best with Navigation Form... if possible please guide here, I added new Navigation with Test name & tabl2...

No dear I'm asking about checking for null field or NZ in form and then in textbox property sheet, Data tab and Enabled" Yes/No"... How to enable that in VBA.... Maybe we need to write VBA on load form but how set property sheet>Data Tab>enabled to Yes or No by checking textbox is null with...

Dears Experts, I'm in need of your expert assistance, If we created a form based on table but we need to check for empty or null cell/feild values that we left intentionally while filling out the data... But after some time we need to update that feild from Form.... I know We'll check for...