Search results

I went into the Startup settings and disabled status bar, access dropdown menus etc so that the form just pops up at startup and nobody can edit the database -- and now I cant seem to get back in to edit it myself!! What do i do???

See my check box 'Lock this value for all new records'?.. well it doesnt actually work.. how can I make it work..? ie: when I select Julie Devenport, enter all details and click 'Add record' that it will stay on Julie Devenport for the next data entry...

That works great ! I need to use that code for the other two fields. Do I just paste that code in 2 more times? example Private Sub tglE1_Click() Call CorrectCodes(Me.tglE1) End Sub Private Sub tglH1_Click() Call CorrectCodes(Me.tglH1) End Sub Private Sub tglM1_Click() Call...

Ill have a look at that now :)

If I select 'Julie Davenport' then the database should automatically enter 'Teesside' and 'Land side' to the 'Venue' and 'Pitch' field into the 'MAIN' table for that record. Storing duplicate data is not a concern. Please, does anyone know how to do this?

Hi, I need to apply the following validation rule to a form text box. The user can enter either the letter H, W, M or E or any combination of the 4. The user should not be able to enter any other charecters or multiples of the same letter.. ie. HH. Also, the user should not be able to enter...

Could somebody help me with my new form. I have completed most of it but just one bit I’m having trouble with. Please view attached Access file for reference. When a user selects a ‘SalesExec’ ie. ‘Julie Davenport’ the form should look at the ‘SalesExec’ table and see the Julie Devenport is...

Sorry Duck, I cant get it to convert to Access 97 :o Remember you first example dbGrrr, do you think you could do an example in that one? But seriously, you dont have to :) Ive learnt a good bit already, thanks

Yes ... I created a combo with 2 columns, set one column to 0 width. I set the AfterUpdate() event and selected the code builder and put the line: Me.Requery. :confused: :(

OK no probs, forget about the date thing :o :) . how do I get it to count sales by site? ie. How many sales in Bristol today? ps. Do you know of anyone here on the forum that might know how to use the crossTab querie to count sales by week? Cheers

Yeah Peebles is a strange name but believe it!! :D I have been doing I bit of work over the weekend.. I learnt a few things. Heres what I've done so far (attached) Now what I want to do Is to be able to ask the database the following.. How many Sales did Bristol to today? This week? Ideally...

OK Duck, Thats worked an absolute treat. Now I have a cleaned up version of the spreadsheet. I have also updated the DB for the SalesExecutives area. You might want to take a look. Off for the weekend to do some reading. :) thanks for the help so far!!

Surely throwing ducks in an offence? Thanks for doing the spread sheet, it works like a gem, I have added some more sale executives to the list but now some fields in the export array are showing up as #N/A. I have double checked the formulas / read the help and understand them but it's not...

Hi Duck, I have attached a sample of the speadsheet that I recieve every day. In reality it contains about 40 columns of information but for the database we only need information from the first 6 columns. From this sample spreadsheet I would like to just import it into the access database and...

I'd be askin a bit too much of you but could you do an example, same as the last one, but with all info in just one table? I been trying to do it myself for the past hour and I just cant get it to work. Sorry for takin up your time.. i appreciate the help!!

Hey thats fantastic.. I appreciate the help :). It will help me understand how it works. Just one question though - you have 3 seperate tables in the database. Is it possible to have all the information in just one table as I will be importing large speadsheet files into the database every day...

Hi all! I have a really simple database with a small amount of information. Each entry is a sales transaction made by Tom, Sue or Ben on a given day, at a given venue. The database table looks like this: SalesExec --------- Venue --------- Date =============================== Tom...

OK I have figured out how to get it to count =Sum([SalesExec]="Sue") This will count how many sales sue did. Can I make the forumla ask me which person I want to choose instead of having sue in the formula.?

I can use: =Count([SalesPerson]) and this will just count the amount of sales of all sale people. How can I get it to count how many sales of just Sue. Something todo with criteria?? Please help :)

if someone could give me a simple step by step to start me off it would really help. Thanks