Search results

Thanks for your response. The problem is that I want to pack it so that I wouln't need to start MS Access again, and so it would just run independently. But with winzip, it is still dependent on Access. Thanx again

Hi, can someone please tell me how would it be possible to package my database!!!? I need to do it for my coursework. I thought may be the package and deployment wizard would be a good idea, but it isnt listed in my add-ins manager. Btw I am using VBA (Access and VB together). Thanx in advance

Sorry about that, won't happen again. And by the way, how do you do this thing that you said, update or populate

Report Visited Count Hi, I have a Report called Product Details Display, which shows a few items. I want to create another report showing the number of times the "Product Details Display" report has been visited on a single day. I dont know if it is possible to do it for a single day, but if it...

That looks good, but what do you actually write in the function (or subroutine)

Yes, that works perfectly. But the button enabling doesn't work. Can you please help me with that

Hi, I have a form called Product Details Display Form, which is for Product Details Display table. This form contains a button "Done" which saves everything into the table, or in other words, bounds the unbounded textboxes to the table. Basically, I want this button to be disabled at the...

Hi, I have a form called Edit Column, which contains two text boxes: ID and Description. The user types something in these two boxes and presses a button, and this button should take the value of ID and edit description for that particular ID in the table "Map". Here is the code I have written...

Thanx a lot guys. It was great. Thanx

I just wanted to ask how to change the msgbox style, for example, put a Critical or Information picture on the side of the message box Thanx in advance

Thanx a lot mate. It works perfectly

Hi, I have a formcalled Register and this table contains Name-of-Employee, Username and some other fields. The form searches the Register table when someone wants the register, and if the username is already taken up by another user, it gives a message box saying that the username is already...

Well, I'm trying normalise another table, and that's why I made this new table for columns. But anyway, I dont think I can normolise the Column table because each column has three racks which are completely different from the three racks of another column. The other way you told me, compound...

Hi, I am in a great hurry and I need someone to help me as soon as possible. Basically, I have a table called Column, which contains 4 fields: Column (autonumber, primary key) Column Description (text) Rack (number) Rack Description (text) There are around 30 columns, and each column has 3...

Thanx for your help. But how do you use the two software that you sent, or download them. The websites are so confusing Thanx in advance

Hi I am using VBA for my coursework and I really need to package the programme. I have heard of the Package and Deployment Wizard, which is supposed to be in the add-ins section in the VBA, but for some reason I cannot find it. Please help with this, is there any way to make it work, or maybe...

WOW thanx a lot, that works now. Thanx for your help mate.

Well, I did that, and I see some improvements, no error messages. But now it only displays the first item in the table, as it did before. Here is the new code I wrote: Dim db As DAO.Database Dim rst As DAO.Recordset Dim strField1 As String Dim strField2 As String Set db = CurrentDb() Set rst =...

Thanx for your help, here is the code I wrote, and following error comes up (see line 11): Dim db As DAO.Database Dim rst As DAO.Recordset Dim strField1 As String Dim strField2 As String Set db = CurrentDb() Set rst = db.OpenRecordset("Map", dbOpenDynaset) rst.FindFirst ID = 6 strField1 =...

This may seem a very simple question, but I really don't know how to do it. Basically, I want to MessageBox contents of a table with a button. I have a table called Map, and has two fiels: Column Number and Description. When a button is pressed, then I want a messagebox to come up and show the...