Search results

Where is the best place online for a beginners tutorial for VBA? (free perfer) or otherwise. I know just enough to get myself stuck Any Ideas?

Alright....I fixed it. Ran it again and got a compile error on sHostName = Environ$("computername") Thx

Hello All, I have an Access db with the back end as SQL. Someone has some vb code attached to a button in the form. It works fine when it is just manipulating data from a table directly in Access. But now that I have the same table in SQL linked to Access I am getting an error. I also have...

Ok...I am following you. I went to design and right clicked on the text box that is named "ProductID" Then to the event tab and after update put the code in. My table is called "product". I guess I'm confused as to what field in the table it would be updating or where it would put the...

Thanks very much! This is how I have the code Private Sub Form_AfterUpdate() Dim dd As Date Dim dbs As DAO.Database Set dbs = CurrentDb dd = Format(Now(), "dd/mm/yyyy hh:mm:ss") ' Get Host Name / Get Computer Name sHostName = Environ$("computername") ' Get Current...

Hello, Yes I do

Thanks, this does help, however my main problem is how to record date and time when the record is changed. That can be added to show who made the change. Any Ideas on how I can accomplish that?

Hello All, I am trying to figure out how I can put a time stamp in a field when the record is changed. I know I can do a =Now() or something in the form but I would like for it to be a record in the table. So this is what I mean If I change a record It would record the date and time in field...

I will try with a query and see if that makes a difference.... Thanks

Hello, Yes I am

Hello, I have a Access DB with SQL as the back end. I have some simple calculations in the form that work when it is not connected to SQL but does not work when connected. Example: I have a subform in this form. Is uses "=[RoutingSubform].[Form]![costpcsum]" to display some data from the...

Thank you very much....this was very helpful. Thanks again Take Care!

Hello Thanks for the help! I still getting an error when I put DMax("Product ID", "Master Product List") + 1. Maybe im putting it in the wrong spot. Just to test. I created a text box and put the dmax in and it came back "#error" So I dont really know what im doing wrong????

Hello, Yes, each database contain a table with product id. Im just taking the data from all 3 tables from the 3 separate dbs and combining them into one database. I will be then uploading that table with all the data to SQL for backend once I get this to work. After combining all 3 in to one...

Hello All, Here is my issue. I have 3 Access dbs that all use a field called "product id" that uses autonumber. The person who set this up is using the auto number like a part number. I need to combine all three to together but when I do it will not let continuing using autonumber because...

Thank you very much I will try it... Thanks again!

Hello all, I think I have a simple question. I have a regular form with name,address,phone and so forth. I am trying to display the name in the textbox but when you click or tab to the textbox the default text goes away. However if the field is blank then it will display default text... Is...

Hello All back again I have created a switchboard for the main screen for my database. However, I cannot resize the form??? I just want to have a small dialog box for the menu not the full screen. In 2003 it very easy to do this....it can't be this complicated?? Please help Thanks

What up buddy... I am going to try my hand at UDFs to see if that will work. If I run into some problems I will let you know... Thanks pz

Hello, Could someone help me with this code? Just trying to do a vlookup that will reference the exception sheet whether Im on a new workbook or not. I just want to put in zlookup and it will look up B2, on Exception Report Test.xls]TABLE'!$A$2:$D$126. Is this possible?????? Function Zlookup()...