I am trying to rank the records in my Access database based on a field which contains the sum of other fields. I need them to be ranked in order from greatest...

Hi, I was just getting started using SQLand came accross a construct I plan to use:- CREATE VIEW xyz AS SELECT * FROM abc WHERE condition

I am new to acccess, we thought we would try it to see if it would be easier for what we are trying to do in excel. In excel I made a workbook up with...

i need a docmd or something like that to place a subform into new record mode (like nav bar * ) when i push a button on the main form. this is a quick and...

I'm trying to use MS Access 2003 SP1 to link to a dbf file. I do not have dBASE or FoxPro installed. When I use the Table wizard to link to an external file,...

Hi, I'm trying to set up a database and I need some help. I need to set up two tables so that when information is entered into one table (call it Table A) it...

How do I get a phone number field to diaplay correctly in a data access page. I have my table set with a phone number input mask. When the data display is the...

I split my database and uploaded the tables up to our website. Now everytime I try to link the tables I get an error "not a vaild file name". I'm not sure is...

How do you set up a listbox that is filled by pressing a command button. I have two buttons, if you press button 1, I want the listbox to fill with certain...

I have an unbound form containing an unbound subform. I'm using an insert SQL statement to put the data into the table from the subform and binding the...

What does a square with a red X in it mean?

I have an contact history table that contains a variety of fields including contactid and completedate. The completedate is automaticaly populated with a date...

Hi Group. Access 2000. Win xppro. I have created a command button to delete the current record on my form. The command button created by the wizard uses the...

SELECT webstats.Tijd, webstats.Computer FROM webstats WHERE (((webstats.Computer)"192.168.0.204")); if i put * after 192 i get a syntax error. with left...

i am trying to create a combo box that will allow users to pick a year value from a table and I am trying to limit the choices based on what is in...

Very much a newbie here. I'm trying to generate a report with user defined date range that has multiple subreports in it. I've got a query with parameters set...

I need to run a query against a date field so I can see how many items have been added this week. This needs to be a perminat query ie click a button and it...

i forget how to reference a field on a subform on the owner form. something like form.fieldx.value = forms!..value tia mcnewsxp

Here's the deal, I have a report with 36 "boxes" each with 3 expressions that look like this =DSum("","there"," = 'who' AND = 17") OK, the "who" changes in...

Hi, I have 2 tables: Table1 where I put the employee number with his name and last name and table2 where I put the employee number ( with out name and...