Recent content by shaley86

Paul I don't know what I'm doing wrong, I tried doing that again it's still not working!!!!...can you send me back my database with the changes noted you speak of? I would like to compare it to the one I'm working on and see where I am going wrong. Getting super frustrated with Access!!!

Hi, I did that but did not save it as it did not work for me...could you try it?

Thanks Paul please let me know you receive it...

It's declining it, it's too big - 5600 Kb, even after I compacted and repaired and compressed the file. Any way you can private message me your email and I can send it that way?

That still does not work for me...Is there any way that I can email you my database?

Hi, I am modeling a new database after an old one. There are a couple of fields called "Subject Code" and "Subject." In the old database, when you type in the Subject Code, the Subject automatically pulls up, without having to type it in. In my new database, I can't get that to happen; I'm...

Hi, I have a query that when I run, I have to enter the date parameteres TWICE. I have read other help forums that state I need to clear out the "filter" and "order by" property fields in the Query Property Sheet, which I did, so now they are empty. The query then ran fine all day yesterday...

Now it won't even let me add up the sum...This is the error code that I get when I have inputted my formula: =Sum([Number of Smoke Alarms Installed])A warning symbol shows up which says: "Data type mismatch in criteria expression."This is the exact same formula that I used in last year's...

Thanks, that worked using the Help Feature. I have been using Help but sometimes if you don't know the exact terminology to use, ie. "Tab Order," the help doesn't help much.....I had no idea it was called Tab Order.Is it possible to add up anything in Access Reports that DOESN'T include...

how do you do that?

Hi again, Is there a way to make the cursor go from one textbox to the next? Currently, when you open up the form, the cursor is in the second textbox.... but I want it to start in the first textbox, then with using the arrows on the keyboard, go from one box to the next. Right now, when you...

thankyou!!!!

Hi Everyone again, I am now having a new problem with my form. Whenever you close the database, then go back into it, the data that you entered last is what shows up again. I want to have all of the fields in the form BLANK each time you enter the form. Do you know how to fix this?

Thanks! i got Bob's reply first and it worked like magic!!!

Hi, when I open up my MS Access 2010 database, all of the Access Objects are along the left hand side and nothing is on the big screen in the centre (until you click on of the Access objects). I would like the objects to appear along the side, but the Form to be automatically on the screen when...