Search results

I agree with the KISS philosophy, but sometimes you can't do what you want with KISS. I've attached a database to this post to show you what I want to do. If you get a chance take a look at it. Sometimes a picture is worth a thousand words - this database is the same. It's an XP database...

I upgraded to Access XP a couple of months ago and I just noticed something strange. If you use the program menu to start access and open a database I have all these red lines in my database window. All the forms, queries, reports, macros and table have a red line above them. There’s also a...

I want to move the controls with VBA Here’s what I want to do. I have a continuous form that shows customer orders. The continuous form by default will only show one line for each record. On that 1 line show customer name, order date, and other information related to the order – One line per...

Thanks....but I don't care about sub forms right now. me.Mycontrol is in page footer of the form. I want to move me.mycontrol to the detail section of the form. I want to expand the details section of a continuous form if a user selects "show details” and show 2 lines for each records . In...

Using Access XP I have a continuous form that shows the main fields in my table. In the page footer of the form I have a tab control that has 4 additional fields for each record. I want to give the user the option of “Show Details”. When the user clicks on “show details” I want to move the...

Thanks for your help lobodava

Sarah and everyone else - thanks for your help. There is a more elegant way to increment a number. I also posted on another site and there are some good ways to sove this. If you download my attachment It will do what you want with some modification to suit your particular needs. You can...

No I don't have any idea what the problem is. I tried downloading the zip that was posted. I'm sorry you couldn't open it. I hope others don't have the same problem

Here is a 2000 version

How do you increment a numeric or date field using the plus or minus keys with a sub procedure only. I've created a procedure that increases or decreases a value in a numeric or date field by using the plus or minus keys, but I can't store the value in control without using the after update...

If all you want to do is add counter to an existing table then use this sql. If you try to run when the field already exisis, you'll get an error. ALTER TABLE Data ADD COLUMN NewField Counter

I am trying to run a transaction in my databases and I’m having problems with rollback. I have an append query and a delete query that I’m trying to run Just a test I begin the transaction, run the queries and then rollback the transaction. For some reason the rollback isn’t working. Please...

Have you tried opeining Access? Then instead of opening a database, from the tools menu Select Tools, then database utilities, then compract and/Or repair. If you don't already have a database open you will be promted for a database to repair from and then a database to repair to. Depending on...

I’ve worked with all version of Access in the last 7 years. I just converted all my databases form Access 97 to XP. And XP has gotten a lot worse! 1. Is there any way when viewing a form with a sub form to have the sub form show up as a white box(Access 97) rather than showing the subform in...