Search results

I downloaded the sample Database via link: http://allenbrowne.com/ser-62.html. There was only a form in there. I said extending a form but I should say a dynamic table within a sub-form. Since there are only 5 records in the table at most then I am not sure what happens if we had more data. I...

@ June7 I opened your sample form. It looks great, but it created more questions now: I don't see any table and didn't find where your data are stored in the form. I don't know how to create a dynamic sub-form that extends as the number of data gets more. If I was able to do that then I need...

@ The_Doc_Man Sorry for my typo when pasting the code. The "Debug.Print ..." line is not part of the string. sq and rs are declared in very top part of my VBA module to make sure all the functions have access when needed. The rs is declared as Recordset and sq is declared as string. What I am...

Hi all, I have no experience with this and sometimes I need more clarification in technical parts. I have a select query with multiple tables as you can see in the attached image. I also have its SQL code here: This is my first experience bringing SQL in VBA. I need to have a combo box that...

@ isladogs Yes I did. It didn't help. So I created a new form and now I can see the date() function working. Thanks for your help and everybody else's

@ Gasman Yes. I have. It doesn't fix the issue. I am now creating a new form from scratch. :(

You are right, I have done that before this project. Even in this project (form) it was working that way (2-3 weeks ago) but now for some reason it is not working. I even created a new form and used the same method you and other people suggested and it worked very well. I believe I have messed...

@ isladogs I am thinking about something in my database that prevents the current date function from working. I don't have the option of "Repairing Database" available. What would you do if an unbound control doesn't show the date in your computer? i just created a new form and using the Date()...

Hi, Thanks for help but for some reason neither one works. I have done that before and it was working but now I can't make it. It either gives me error or shows Date() only. I used the expression without quotes obviously. I even tried to add a bounded control to show the date but that is not...

Hi everybody, I have an unbound form, trying to show the current date in a text box. When I put this "Date()" expression in Default Value property of the text box it shows the same word "=Date()" in the text box rather than the actual date when i open the form in from view. I've tried many...

Thank you all for helps. I found an easy way to show all the fields in a text box when I was reading other threads in this website and I realized that solves my issue. Here is what I am using, just for information: Me.txt_car_owner = [cmb_selectCustomer].[Column](0) & " " &...

@ Arnelgp, My column 8 in my combo box refers to owner_ID in tbl_carsOwners. It takes all the ID's from from that table. I am going to work on what you said this afternoon. I have to go to work now. Thank you for help. I will keep you posted.

Hi Pat, As I said before, I am not expert in VBA or Access. I need you to explain your suggestion where you said: "... modify the recordsource query of the form to use a left join to the lookup table." I have a simple select query that takes all the fields from different tables. Did you mean I...

Here is a picture of my relationships attached. This is from the query with 4 related tables. The owner_ID is the value I need to pass around other functions. The owner_ID can deliver all necessary info about any car once the user selects it. Am I doing it right?

Hi everybody, I have a combo box based on a query. Query itself has 8 columns based on 4 different tables. I am using the Bound Column 8 from my combo box as a value sent to another function. I am trying to enable user to select one of the list and then based on the selection all related fields...

I spent a lot of time on your codes and finally I was able to make it work when I changed the name of OldValue" variable to "myOldValue". I believe this was a reserved word in Access so that it would prevent my functions working. Thank you anyway for your help :)

Thank you for reply. I didn't want to copy and paste the same expression into OnChange or AfterUpdate event of all 15 controls which adds too much codes into my VBA module. I am trying to find a simpler solution by couple of functions or changes into my VBA module in order to do the same job...

You are right with bounded forms. Initially I started my project with bounded forms but it would make duplicated records or some other weird actions so that I switched to unbounded forms and using VBA codes I can now control everything with least number of errors.

Thanks for reply. I wanted to have couple of functions that do the job without copy and pasting the same expression into OnChange or AfterUpdate event of all 15 controls which adds too much codes into my VBA module. Your code seems to be the right one. It has only two functions and small...

I have an unbounded form that I can successfully load it up with data by VBA codes. Now I need to create a sub routine (or similar) that once user changes any data in my controls then a button named btn_update become enabled. Can you please help me?