Search results

If your using a form / subform doesnt the subform already have the total records displaying in the record counter near the nav buttons?

What I would do is create a default set of values that are applied when you add a new student.

Is the form based on a query?

I had a similar problem and if I recall it was all of the buttons that are created with the wizards. I had to code everything rather than use the wizards. Not the answer you want (sorry), it wasnt the answer I was looking for but had to get on with it.

Thanks. I had to install the advanced wizard for the link table manager. I thought it was working but then it stopped (there must be some conflict as I have access office 2007 installed as well as 97). I eventually got so sick of it that I converted the DB to access 2007, used the link...

I have an old access 97 db that links tables to an SQL db. We have recently moved our SQL db's to a new server and therefore the embedded connection strings no longer point at the correct server. I can open MySysObjects table and veiw the connection strings but cannot change the server address...

you can turn all of them off and display only the menus you wish, although you can turn database & web back on if your right click in the menu bar.

You make it your main menu, you disabale the main access menu and replace it with you custom one. I don't think you can set it up specifically for the form using this method but it will always be available for all forms. I stand to be corrected and could be missing the point.

Why don't you add columns to your spread sheet for a period number or week number then just filter by that number for your report? Just an idea because as its pretty simple data and access may be over kill for what you are doing. Saying that I would have done it in access just because my boss...

You say you will need to enter the article with prices etc five times, you would need to do that if you had five databases so there is no gain or lose in the amount of data entry. Administrating 1 database is by far so much easier especially if you modify tables, queries, forms ect you don't...

Only done it once myself and used asp, its not that difficult if you understand a little about vb coding because you will need to put sql queries into the pages, dimension variables, pass variabels around etc. You will need to create a system DSN You will need to setup IIS so you have a web...

change the allow additions property

you could try and create a custom menu, you may not need as much code. this link looks pretty helpfull. http://www.jamiessoftware.tk/articles/menubars.html

can you give more details.

I would sort the data in the query, its not dynamic to the users but at least puts a predefined order to the results

not sure if this helps but can you not use the Char(39). may be, may be not?

Not sure why, I have just tested this and it overwrites the file.

Open the query in design mode so you can see the design grid, go to the first empty column and type expr1: followed by your code. save and run the query to see what it does. You should basically see the results of what you want in a new field called expr1. Create the second query just as you...

You pretty much have it with that expression. Create a select query based on your main table and add expr1: with you code into the grid. Create a second query based on the first query, change it to an update query. The field that you want to update put [expr1] as the criteria. Should work...

Thanks for that, although a little complicated for what I want to achieve it did get the mind working and I came up with a fairly simple solution using uinion queries and selecting the top 2 records. Cheers