Search results

I don't think that will work. the LETTER CODE field can be duplicated so can the DATE field but not if they are both duplicated in the same record LETTER CODE DATE a 01/01/01 A 01/01/02 is ok to have in the table but LETTER...

I'm using an UPDATE query, which is run when I click a button on a form. The update query add to a table with this structure LETTER CODE - A single Letter Value - A numeric value Date - A Date The table thats being updated should not have any duplicate records in it...

Is there any way I can use a multi select list box for a query criterea?? For example say I wanted to use a query to produce reports on 3 different people, i'd like a list box to allow me to select 3 people and then pass these into the query for example (again i know this wont work)...

can I declare a variable and give it a value at the same time e.g. global temp ="hello" as string ??? does anyone know if I can do this.

Hi can someone help I have a form with 2 list boxes on it. Each list box has a list of stuff (doesn't matter what really) I have a new table set up as a link entity like so pk_aprimarykey - A replication ID primary key autonumber field fk_1 - Replication ID fk_2...

I'm clicking on File/Get External Data/Import Then I'm selecting the right Excel file. It's a simple excel file With all the Names in column A and all the UserID's in column B Once i've selected the file, I choose to " Store data in existing table" All I get is an error message - "An...

Hi Can anyone give me a quick solution to this problem I'm trying to import data from Excell to Access 97 The data i'm trying to import it simple NAME UserID PersonA AuserId PersonB Another UserID I'm having troubles importing it though because the table it's going into...

How come half the people that post messages on here seem to put nothing useful in the subject line. When your scrolling through the message board looking for answers (or spot anything you may be able to help with of couse), half the time you just get "Please Help Me" or "I have a Problem"...

Is there any way I can simply print my access project? I want to be able to print out all my code and screen dumps of all the forms in one easy(ish) step. is this possible or did microsoft accidently forget that you may actually want a hard copy! Cheers:D ears

Funnily Enough, i'm using Access 97 too. ******* i've just found a sneaky way round this problem . I created a combo box and DIDN'T hide the key column I made the 1st "Column Width" of the combo box to as close to 0.0 as I could (so it wasn't hidden, just really small) then I made a label...

Ok i've just found somthing else out. When I create a combo box for the query to point to. It works if I don't hide the Key field (primary key of type REPLICATION ID) it doesn't work if i DO hide it. (although surely it's just hidden) any ideas???

Yeah I tried with and without. This is a stange one to me. You see it always used to work. I don't suppose it has anything to do with the fact that I split the database? I don't think it should make a difference but you never know. The thing that gets me is the query works in reverse (using...

I created a query that used to work, but now it doesn't. In the query there is a critea section to look for the value of a combo box this is what it looked like =[forms]![report-Team_Performance].[Combo_Team] It used to show all the data for anything matching the combo box somehow (and I...

Hi i'm creating a split database. I update the front end which needs to be sent out to users. In order to keep people using the latest version, I have created a table to hold one record (A Version number). When the front end opens up it's supposed to check that it is the current version (i.e...

Hi i'm creating a split database. I update the front end which needs to be sent out to users. In order to keep people using the latest version, I have created a table to hold one record (A Version number). When the front end opens up it's supposed to check that it is the current version (i.e...

re: "I hate Microsofts dialog boxes - ABORT, RETRY, OR CANCEL!! Help me write my own Can I simply pass a string as a parameter to a form. You see Microsoft obviously still havent realised that their dialog boxes look ....... (fill in own insult here) So i'm going to design my own. I just...

re: "I hate Microsofts dialog boxes - ABORT, RETRY, OR CANCEL!! Help me write my own Can I simply pass a string as a parameter to a form. You see Microsoft obviously still havent realised that their dialog boxes look like s**T. So i'm going to design my own. I just want to make a nice...

How do i do this? when I split the database i just put the back end somewhere and don't know where to change the paths.

hi, I'm in the process of creating a split database. However the company i work for seems to run a policy of "choose your own drive letter", so it's very hard to send out front ends as they will amost surly have a different drive letter to the person sitting next to them. Is there a way that I...

re: how do i make a field default to the current NT username As the subject line asks? How do i make a field default to the username ID. I have a function that returns the Username, but how do i use this function to make the field value (I want to keep it out of the form as it is a security...