Search results

Yes that does work perfectly....thank you... are you familiar with writing macros in VB for MS access? I had a question on that too...

I am using MS Access version of 2010.

Hi, I changed that to the following: Private Sub Command39_Click() On Error GoTo Err_Command39_Click Dim stAppName As String stAppName = "K:\CLE03\M\UsersGuide.pdf" FollowHyperlink stAppName Exit_Command39_Click: Exit Sub Err_Command39_Click: MsgBox Err.Description Resume...

Hi, Following is the macro I am currently using to import data from excel into a MS Access Database. What I want to add is a feature where in if a user enters the date in the wrong format, a message box appears saying "Date format Incoorect". Private Sub importFile() Dim inDate As String...

I am not sure I follow Taruz.. I am attaching my tables in an excel sheet below for you to see...

Hi, So I have a query which selects 74 account numbers, balance numbers for a date that I select in a form. I have embedded this query in a VB Code of the form and have also created a button which selects the date and runs the query. But because I want to view the result in a particular...

Hi, I have a main form like a main menu for the database as a form and I am trying to add a button in the same which can launch a pdf file stored at a location on my desktop. Firstly is it possible to do this in MS Access? Secondly, if yes, below is the code I am trying to work with...

Hi All, I have a VB Module that I use on a daily basis to upload a set of data containing 2599 rows and two columns (one for account number, other for balance value). I want to include a feature in the Module program where 1) I can check if on any day the number of rows become less or...

Hi Gina, I did try to lay down the tables like we discussed but its not looking very good...is it possible for me to contact you through any other mode of communication? Thanks!

Hahaha its funny thing to say but I thought about it too but dint bring it up respecting the decorum of the forum... I am open to any means of communication....just let me know... thanks!!

Hi Gina, What I meant was to see to be able to link Table 2 to table 3. So what i can do is have each GL_Account mapped to BAL_ID? That is possible right.

I understand your view point...I think what I can create are views if not exact tables with all the information possible. So lets say I can see the accounts in each BAL_ID in one with values in another may be.. Do you think that is possible? I am sorry but I have to get this in access...

Okay...I understand that, can I just arrange the tables in such a way that I can see which GL Accounts fall under BAL_ID and the corresponding GL Account Balance? Would you be able to lay down the table names and columns for me? thanks!!

So is there a better way to do this? I can have following tables: table 1 Levels levelid (PK) level value table 2 Sub Levels sublevelid (PK) sublevel value table 3 GL_Accounts date glaccountnumber (PK) glaccountbalance glaccountshortdescription glaccountlongdescription table 4...

Yes that is correct. I can make karts, levels, sublevels, GL Accounts into separate tables but then how can I link them so that when I click the plus sign I can get all information regarding that?

Great, I am online, you can let me know in case you have any questions...

Hehe thanks Gina, I am sure you are busy too...

Sorry about that, I am zipping the file and sending it across now. Thank you for your help.

Hi, I have attached the exact tables that I have in my database for now and some of the tables looks very similar to what you have given me. But it is different from the way you have laid them down. Thanks!!!

Gina, I am not entirely sure I follow the post. So it seems you have given me the names of the columns of the 6 tables I should try to lay down. But I am not sure which column name refers to the columns names in the dummy table I sent across... would it be possible to be a little more clear...