3,842 Topics
 | |
| | 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 …  |
| | I have heard about Access Data Project .Can anybody tell me what is it and when it is used? |
| | Hi All, I am new to working with Access and would like help to stop a security pop up on users when starting Access. It does not happen on all my users but as I plane to rollout Access via citrix I feel this pop up could cause problems. I … |
| | I have a table containing the fields: DeliveriesID // SupplierID // Date // ProductID // QTY // costprice // totalprice I need to make this table 1NF. I know I should make related tables but I'm not sure what fields go with which. |
| | A project a do at my job is a monthly report using Excel spreadsheets. I enter raw data and get calculated totals, averages, etc. Nothing very complicated. Each worksheet is a month, the workbook is a year. No yearly summary is done. Now my supervisor wants some new additional info … |
| | Hi guys, can anybody help, plase. Is there an instrument to manage .edb file (as far as i know Oracle's Enterprise DB but under free licence)? |
The End.