Search results

Hi, I'm currently testing my database in runtime mode to check for proper error handling. I have been told I need to convert all my macros to Vb code modules, for error handling. I've also been told that the filter by form is not available in Access Runtime. Is there an alternative way for me...

Hi, I've finally opened the Visual studio for MS Office systems tools box and found the access 2003 developer extension CD and loaded it, I've been reading the overviews on the CD as always it sounds easy to use, how ever through experience on APPs that is not always the case. Sure enough I was...

Hi, I have a popup form called Labor that is working perfectly fine, what i mean is that it is getting populated with data from the query I built using a single table called PrimaryBid_Master. However I have had to add many fields to this table before invoking a query on it, now I'm running...

Hi, With a table in open view can a record be moved to a different position, i'm using access 2003. Also is there any way to sort besides ascending or descending? I've got a lot of tables to make and if I forget a single column/field and have to add it later (like I have done all ready...

Hello, I've got a text box on my form header with a calculation in the control source that adds values from other text boxes on my form. My problem is that since the calculation is in the control source of my text box I can not save the sum of the calculation to a field on the forms bound...

Hello, I've got a text box on my form header with a calculation in the control source that adds values from other text boxes on my form. My problem is that since the calculation is in the control source of my text box I can not save the sum of the calculation to a field on the forms bound...

Hello, I ran into another programming road block. I currently have a combo box that is bound to a table with 2 fields and has 4 different options/records in it, with an after update procedure, that has different calculations for each record. I want to add a Dlookup command that will display the...

Hello, I have a combo box called (cboridge) bound to a table called (Ridge)with two fields/columns called (dollar amount) (Material type)with 4 different options/records, when the user selects his option/field the dollar amount shows stays visible in the (cboridge) combo box Then I have a text...

Hello, I have a program/database that I'm building in Access 2003, It has new client/bid entry form that has many text boxes for instance: Client, address, Phone numbers, Date etc. These text boxes are actually populating the same text fields in the PrimaryBid_Master form. My question is every...

Hi, Is it possible when choosing a combo box to have it make a text box visible, when in this text boxes properties you've chosen visible=NO. Can an event procedure or some code be written that will make visible=YES. Thanks any help with be greatly appreciated

Hi, I'm in the process of building a program in access 2003 for estimating roofs, I've ran into a little problem, as described below. any suggestions would be very useful Populating the text box’s that relate to the chosen combo box’s with the sum of a calculation. In other words if X combo...

Hi, I'm using a scrollable mouse and I'am always accidently hitting it while in access 2003 and it keeps changing the records, Is there a fix for this with out changing to a non scrollable mouse? Thanks-- Appreciate any suggestions

Hello, I have an append query attached to a text box called client on a form, and every time I enter data into this text box and click the next text box last name I get this error from microsoft office Access that says (You are about to append 0 rows) (Are you sure you want to append selected...

Hi, I have a form in 1 Access 2003 database that I would like to add to a different Access 2003 database as a pop-up form or as a sub form. Can this be done with out having to re-make the form in the other database? If so can you please describe how. Here are print screens of both databases...

I have recently installed access 2003 w/access 97 installed both are on my hard drive. When I create a new db in access 2003 it saves it in an access 2000 format. Does any one know why it does this? Thanks--Appreciate any help

Hello, Is it possible to install two versions of MS Access on the same O.S. I already have Access97 installed. Now I want to install access 2003 without it up removing my previous access 97. If it removes/upgardes access 97 to access 2003 I will not be able to open my access 97 database. Is...

I’m re-designing an access 97 db to Access 2003 and adding a few changes. I’m using option buttons (But I’m not sure if these are the correct object boxes for what I’m trying to accomplish) on my form in Access 2003 to calculate a bid/estimate for possible customers. There are approximately 5-6...

Hello, I'm currently working on re-writing my db from Access 97 to Access 2003. I will be making a runtime version of my db. Using the Visual Studio 2003 Tools for the Microsoft Office System, which has the Access developer extensions on them. I was told I will need to have decent error...

What is the maximum amount of filds/columns a table can hold in access 2003? And what do you do if you have a form and its record source is a table that has run out of fields/columns? If I remember right in access 97 it was 256 or 257 fields/columns was the max allowed. And it seemed to me it...

If the same program was made in Access 2003 and in VB.Net 2003. Which program would be larger in Size of Bytes? And then once there zipped which one would be larger in size? If I make my program in Access 2003, Which I'm more familiar with, Instead of vb.net will it make it to large for...