Search results

@Majp, I did what you suggested, I get an error, error 3075 missing operator, and it will highliht a .txtbmt_date line. I just uploaded a screenshot of my form, and set an explanation well, so any of you could picture out my problem about dlookup.

MajP I used unbound controls yes, so the user can still update data when needed to the particular chosen person/fullname. I used tab controls because I have 3 forms to show off.sorry if I confused you that much "tabscontrols" is my main form. Thank you for suggesting recordset anyway.

hello there, I was able to solve it after hours of working on it, so in my tables, I have Date of Death field, and was calling a specific data on using full name, I just removed some spaces like dateofdeath and it works, somehow, I have problem again on DLOOKUP. I used loads of dlookup value to...

Thanks for the help, I will work on your suggestion. Just to make it more clear, TabsControl is the main form I used tab controls(named as TabCtl17) and one Subform which is Child15 I used another subform and embed it on tab controls (to call 3 forms) that is child23. Dropdown of full names...

Hi @CJ_London, thanks for the response, I put double quotes because I include this inside VBA code, which requires me to put double quotes. The scenario is, I have drop down which is connected to "FullName" field, and once the name is selected, a textbox will be automatically populated, and I...

I just want to retrieve a set of data on Database using the specific full name, however, all is ok except 1 textbox, and I am getting #Error, as I want to reload the data, I compare it to other DLOOKUP formula I set and all is ok and no problem at all, I mean except the dlookup function below, I...

Any idea on how to construct an "If Condition" to reference if the tab pages has been selected? Thanks.

So how to know the pages was selected? I need to create a VBA inside and want to use an IF Condition.

I have built a Main form: TabsControl Inside the main form was 1st Subform: HeaderRisk (on top) 2nd Tab Controls: TabCt17 On my tab controls, I include 3 pages with 3 subforms embed on it. Somehow, I want to set a condition if the tab page was selected, it will perform a specific action on...

Thanks, @isladogs, I will suggest that to my client, I started the project with tabs control, but I was amazed at how the navigation form works. Maybe I switch it back using tabs control again.

@IslaDogs, apologize if I didn't notice your response on this thread. My client just wants it that way(navigation control), but if there would be a suggestion, should I suggest to used tab control instead? Do you think guys It will work now? Thank you.

@June7, regarding to your question, the form I am using, recordsource connected to the tables, but the controls are unbound most, The form with recordsource, is within the navigationsubform, so I can't configure how to change the controls to unbound to bound.

Hi Micron, your opinion makes sense to me now. I used unbound control because I set some condition on some controls. Maybe I am not really familiar about append and update query yet. Thanks anyway.

Hi Micron, I really appreciate your response on my thread, however, I am using unbound controls(corrected me if I am wrong that this control not bound to the database), some of the controls are usually combo box and 1 list box, and 5 textboxes. Since it was unbound control, would it still be...

Hello there, Just a quick introduction to myself, I am Emina002(username), and my current role was being a VBA Developer in Excel, I am really want to learn more about on VBA Access. I already developed some system using MS Access. Right now, I am working on a project which gave me a hard...