1,597 Topics
 | |
| | Is there another way to make a column in a table the primary key if you already assigned it to the autonumber column? I would like to make either the student id or the social security number the primary key. |
| | I have some accumulated error data organized by week. How can I write a query to pull the top 10 or top 10% for each week and show them in the same table? I will need it to be flexible enough that it will continue to function properly as I … |
| | Hi everybody, I hope you can help me tackle this little pb. OK, I need to create an access database aimed at booking salesmen trips to different cities (NY, Dalllas, Washington, Miami). Basically, I'm using 4 fields: Saleman, Location, Star Date and End Date. Now, I need to create a … |
| | Hi, I created a report that prints a collection of pictures (jpg files). But it turns out that one pic will occupy one page. How do I create a report that display the pictures continuously? This means that if the pictures are small, more than one can occupy one page. … |
 | SQL is very simple language, even though not everyone is able to use it. In many cases good WYSIWYG SQL editor (or composer by better words) could help. But is it possible to graphically represent all SQL commands? Simple queries - why not? But what about those, not very simple, … |
| | Dear colleague: with out placing an ADODC object on the Vb form, I want to create a connection with a SQL server database. And add record in the table, retrieve a data from a table and amend some data as well, through textfields in VB. Please forward me the code, … |
| | Hi everybody, I have been asked to build tools like you will find at [url]http://www.stevenscreek.com/goodies/pi.shtml[/url] [url]http://www.fitnessandfreebies.com/tools.html[/url] [url]http://www.global-fitness.com/freetools_m.php[/url] I sincerely do not know as I dont have a ready database to retrieve data from for these calculations . Please could anyone tell me from where i could find such data ? … |
| | Hi everyone, I'm keen to use Access as a client application to access data from a MySQL database. The reasons are Access for its strength in reports creation and MySQL for its stability and scalability. I also intend to site the MySQL database with a web hosting service provider. This … |
| | Hello , I wish to Duplicate certain Fields in the same tables when i open a new form that is related to that same table . If i create a button of Duplicate Record , he will duplicate the Primary Key - which i do not want to "Duplicate OK" … |
| | [CENTER][COLOR=Navy]Hi i am creating a database im ok, just havent used it for years and years. I need a defult value which will add todays date. And a validation Rule that will prevent date entries prior to 1/1/2002[/COLOR] [COLOR=Navy]Can anyone please help me!! Thanks Jay[/COLOR][/CENTER] [CENTER][COLOR=Navy]AND MY INPUT MASK IS … |
| | right when i type the date in a need a validation for it dusnt allow u to book any less than 7 days in advance from NOW (DATE cz i dont want time included). If longer then 2 months in advance also dusnt let u for as computing course work …  |
| | Hello We got to work in MS Access with creating this database for a company. Anyway I have a problem with a form where I will registrate new Products cause I don't want to have one of the secondary keys in the form even, but it keeps telling me I … |
| | Okay here's where I am at currently... RELATIONSHIP: Personal Profile ---One-to-Many--> Receipt Totals ------> Service Performed The personal profile & receipt totals are connected via Customer ID while the Receipt totals and the Service Performed are connected via Receipt ID I have them all together and they work just fine. … |
| | trying to get back into programming after 10 years out. this is very simple i'm sure but I get an error message 'invalid syntax, missing operator or operand when I enter this into my control source box in access reports module. Can anybody help? Thanks |
| | I have a macro that copy-paste from a sheet to another... in that file i need to change the name of the sheets all the time, but the macro code does not understand that and gives me error... Sub Copiar3() ' ' Copiar3 Macro ' Macro gravada em 02-12-2005 por … |
| | Anyone been through something like this and have some good suggestions? I have a password protected MS Access database that stores comments (as well as a slew of other things) that people are updating. I have the same database on my home computer that I use to update other information … |
| | Hi all, I'm importing external data into Microsoft Excel XP from a database. Not wanting to query all 70 databases we have I'm thinking a macro or some visual basic would work nicely to automate this. However, I'm stuck because everything I read tells me that one cannot query multiple … |
| | Hi there, I am not the bet in Access, I will admit. But need a function to open up a MS Outlook template (.oft file) within Access. Anyone help with quick steps on how to do this, It would be greatly apprciated. |
| | Does any of you know what DBMS products are suitable for internet database system other than Oracle 8[I]i[/I] ? Thank you? |
| | I have just had the dubious honor of being given a 500k Access database to manage that is not allowing me to do any inserts. I have administrative permissions both as a db user and on the db itself yet the insert button and drop down are all disabled. There … |
 | Hi, Here's my task. I have to setup a Crystal v10 report to print a label to a tharo barcode printer whenever the record is saved in the access db. Or maybe setup a checkbox "Print Label". When the checkbox is checked and then the user hits save, that would … |
| | I was wondering what the pros and cons of form and field validation are? |
 | when i click a link into my page, it will then open a new window which is connected to a database. when it loads.. after 2-3 seconds the "Page cannot be displayed error" will then occur.. is there something worng with my connection? what is the problem with this? i … |
| | I'd just like to know if anyone can point me to some good resources for creating charts in Access 97. I'm trying to modify a bar graph and I can't get it to do what I want to do. I haven't done much work with charting before and everything I've … |
| | Our organization uses an Internet website to create travel orders. The orders are sent to their supervisors for approval. Many times the employees forget minute details such as taxes. I want to create a basic report system which allows a user to check (from a list) all that apply; i.e. … |
| | Okay, another easy one, but I can't remember how to do it. I have a table that I want to be able to update multiple records in. I thought I could just run an update query, but I have 2 yes/no fields and one text field that I want to … |
| | I am making a database that tracks the inventory of a tool room. This includes info about both shelf tools and tool box inventories. Each inventory has about 300 items in it, and there are about 9 kits. The info was already put into excel, and instead of re-typing the … |
| | I want to develop a new app. for Windows Mobile 2003 that based on Access DB do you know about a nice place where i can read about it and get some nice tips? If you know about some other app. that uses access DB or any other DB for … |
| | i have a very simple access DB and im tryin to update the records but the update never works. im using asp.net/vb.net and i've include the execute in a try/catch block and it always prints the sql string (the catch). here is my code, perhaps i have an error that … |
| | Heya, I have a table that has a primary key that is generated automatically by the database, so when I write an SQL statement in my program to insert information into the table, I insert values for every field but the primary key field. The problem here is that in …  |
The End.