Search results

Hello, Is there a better alternative to CDate function which can convert a string to a date and also asks for format of string date being input. For instance, a string "01/07/2021" can be January 7, 2021 and can also be July 1, 2021 depending upon what was the formatted when this date was saved...

I changed the function in module so that it save currently selected calendar and restore at the end of conversion. It fixes the issue of second date incorrect conversion. Thanks for help. Issue resolved.

I have checked the file. It is working partially, i.e. for date 1 filter is applied correctly but date 2 filter is not being applied correctly. To check, please set date 1 = 09/01/1443 and Date 2 = 06/12/1443 (to skip record of 06/13/1443 date). I see immediate window for created filter string...

Thanks a lot for reply @arnelgp, I'm away from PC for two days. I'll check and let you know as soon as possible whether it works for me or not.

Hello, I'm the demo database attached, records are being entered into Hijri dates. Date 1 and date 2 are two unbound textboxes used to filter records. I'm trying to filter records between certain Hijri dates, for instance between 06/01/1443 and 06/13/1443. If records are entered in Gregorian...

Thanks a lot, problem is solved. Table is visible now after running the provided code. So nice of you.

Thanks @isladogs for reply. How can I change flag value to 0. I tried but it is not being editable.

Thanks for reply @Uncle Gizmo, RefreshDatabaseWindow didn't help. Even C&R and also closing and reopening the db didn't help.

Hello, I'm using following code to transfer a table along with its data into other db (backend db of another FE) which already has a table with same name. I intend to replace that table with the transferred one. Also a field in the table is an OLE Object data type. Dim db As dao.Database...

Thanks a lot for your reply and your time. Actually in my app there is a filter which uses macros to create filter during run-time (on a emulated split form). While creating filter it saves object type in acObjectType format using screen.ActiveObjectType and object name where filter is being...

Thanks for the code sample but pardon me for saying that I could not understand how to implement it to get object type form report or query or other object as acObjectType as I'm still a learner in VBA. And also I get error something like "user defined function not defined" when I try to use...

Thanks for the link and demo db. I might not have understand it properly but I think Flags of MSysObjects do not gives object type in acObjectType (please click me) format. Like the db you provided, Form1 is a form and flag value is 0 whereas it should be acForm (i.e. 2). I created the...

Hello, Does there exist a function which when passed an access object gives its type in acObjectType format i.e. 2 for form, 3 for report and so on. I need to find and saves object type in a table but couldn't find any such function. Before, the same was being performed by macro using screen...

Thanks a lot. I had written almost similar to this class. I was having trouble re-hiding the combo after exiting the combo but got idea from your class to put the code to hide cbo in OnEnter or OnGotFocus event of textbox. Thanks again.

Thanks a lot, it is working.

I mean whenever txtTarget gets focus, following code in the OnEnter event moves the focus to cboSource. If IsNull(txtTarget) Then cboSource.Visible = True cboSource.SetFocus End If

Thanks a lot @arnelgp for the demo. But in this case the control has to be hard coded. I want this function relative to the combo as I am writing class module and this will be used in multiple forms multiple time.

Thanks for reply but when my textbox get focus, combo is set to visible so focus moves to combo. When user presses shift tab again, focus moves to textbox and again OnEnter code of txtbox is run and focus moves to cbo again and loop continues that is why I wish to move two controls back when...

Thanks for replying. While filling the form, user navigate among the controls using Tab key on keyboard. Tab order is correctly in the form. The aforementioned combo and textbox are overlapped each other and combo is set to invisible. When txtTarget got focus using either by Tab key or by mouse...

Hello, I have a combo (cboSource) and a textbox (txtTarget) in my form and when cursor enters into txtTarget , txtTarget_Enter event is trapped and have code to move the focus to cboSource. When user presses shift+tab, it cannot go back so want that if user presses shift+tab in that combo...