Microsoft Access / VBA Forum

How do you set-up number buttons, much like a calculator to be enteed into a text field. Right now I have macros attached to each button 1 to 0 but I can't get the numbers to append to each each other, they just write over one another. DS

A query contains the fields CustomerID, CustomerName, OrderID and ItemID. The query is based on a customers table, orders table, and order details table. The orders table has a foreign key of CustomerID and is joined to CustomerID in the customer table. The order details table has a foreign key of OrderID and is joined to OrderID in the orders...

I am doing a study on access 2003 for a database class. I am trying to determine what SQL access uses, such as relational algebra, tuple calculus, domain calculus, etc. Can anyone point me in the right direction?

OK...I am creating a report...much like a letter. I have a text box. It is supposed to hold the LLC Name' The database is "Client Info List" The field is called "LLC NAME" The text box has in it..."=!" no quotes of course in the actual text box.

Hi all, I am creating a fairly simple database using Access 2002, as most of the people who will be using the database don't have access installed on their pc's I was trying to use the Page object feature (HTM(L) pages) The problem I have is I need to create some sort of search feature so users can find specific records, based on a...

I have 101 fields (Field name P1, P2 .... P100 and Result) P1 to P100 has random numbers from 1 to 10. I want to run a query to update the 101st field (Result). It should check the entire record 1 and find out count where the number is greater than or equal to 6 and update the result field accordingly. Eg. P1 P2 P3 P4 P5 Result

Hi i have a database which has always worked fine. However, today there is a problem with it. I get an error ODBC -- Call Failed when i click the print report button? Any ideas? Code for the button is as follows...

Hello! As subject says - these three OSes are target platforms for my app, which uses MDB files (but not MS Access). I know that Jet DB engine comes with XP - what about other two? I do know about availability of the engine and that I can redistribute it, what I'm trying to find out if these OSes already come with some version on the engine?...

test test test test tes

I am screwed and need some help. OUr last VBA programmer put a password on the code in our Access2000 project, so that we cannot get in . Is there a way to bypass this.

I've dabbled with VBA in Word and Excel and generally can get what I want accomplished but I'm having trouble in Access. Mainly with how to identify the location or address of where a particular bit of data is kept. I have a database with a main form for data entry. There are queries that I have that will bring up various types of data on...

I was wondering if anyone knew how to create a report from information that you select on a form. I have a few of the fields on the form linked to a table, however some of the other ones are not linked, and are totally separate. Thanks. DC

When I enter data into my access db through the gui, my SQL Query recognizes the data it is looking for and returns the result. ie I enter "Dog" through the Access GUI and when my SQL query asks for "Dog" it returns all the records with "Dog" in it. The problem is if I enter "Dog" through my ASP web interface to exactly the same database, I...

Hi there, I having a problem with a database I'm setting up, I would be delighted if someone out there could help. The database I'm setting up is a task register datebase, it will be used to create work schedules for workers in a metal work shop, based on the tasks required to make a part and the tasks required to make the subcomponents...

Hi I'm trying to prevent users from moving between different records in forms in Access 2000. I've turned off the record selectors and disabled the mouse wheel. I've now found that you can reach other records by tabbing through all the controls on the forms.

HI, I'm having a problem with the following query. Here it is in my own words : Table : T_Test id (Autonumber) dtmStartDate (Datetime) format dd-mm

I have a form that has three text boxes and a command button. For textbox1, I can tab to the next field and enter into that field. If I hit the enter button while I'm in the textbox1 field, it also tabs to next field. However, I want the form to run the code in the Command button instead when the enter button is pressed. How can this be...

I have inherited some databases which were originally created with Access 2.0 and have gone the conversion route of '95, '97, 2000. I now need to convert them to work in Access 2003 and with XP. However, I was left with next to no documentation or security account information and have been unable to join any of the work- or usergroups to be...

Hi there, I tried posting once already, but Google crapped out and this posted under a different topic. I'm trying to take three columns from one table, insert them into another existing table, but match the values (of the three columns) up with a common field between the two tables. Using Access 2000, how can I do this? Append? Update?...

Hi All, This is what I'm trying to accomplish: I have a table with the following fields - - - (where type can be either B or C) | UID | OrigUID | Type |

How does one set up a multi table runtime parameter based on fields selected from Combo boxes (4 to be exact) for a form or report. Yes it is possible I have seen it but not in Access. I need some clues as I have tried different options without success. ie SQL statement,filterproperty . Regards

I'm helping someone implement security for a small office. They would like to use just one sign-on for the people at the front desk - so 3 individuals would be signed on as the same user at the same time. Will security allow this, are will each individual need a different sign-on. Thanks

I am being thick. I have a table of employees - EmpID & EmpName I have a table or wage rates for each employee - RateID, EmpID, WageRate RateFron (Date) I have a table of payments - PayID, EmpID PayAmount, DatePaid how on earth do I do a query to give me EmpName, DatePaid, HoursWorked. The Hours worked is calculated from the PayAmont and...

When I enter a date in the textbox on my subform, such as 11/22/30...expecting the textbox to show the date 11/22/2030...instead the date 11/22/1930 shows?! Why? I checked the table for the specifics regarding this date field and also checked the form to see if there was a way to override this. Any ideas?

I have a syntax error in my folloiwng code. Would you help me to fint it ? Dim StrSQL As String StrSQL = "DELETE tblEstate.*Houses FROM tblEstate WHERE (((tblEstate.Houses.Value) Not In (SELECT Max(tblEstate.Houses.Value) AS MaxOfValue FROM tblEstate.Houses)))" CurrentDb.Execute StrSQL End Function