3,842 Topics
 | |
| | Hi, I am trying to deploy an Access database application that refers to a dll in VB code using a DECLARE statement. I wrote the dll in using VC++ 2005. I have tested the dll and it really does work fine, on some systems. The application runs on one computer … |
| | Hello, Does anyone know how to extract data from a record for a query? For example I have a sample number (Example: 1555A-S-070202-105500) and I would like to query todays date against it, the 070202 part of it. I would like to have Access show me all records with todays … |
| | I need help in setting up a connection string from MS Access to Pervasive SQL.:rolleyes: |
| | Hello, Being a novice at MS Access and the help menu being of no help I would like yours. I have a form that has combo boxes with the pull down information entered in under Row Source Type as a value list. The value list shows what I wrote in … |
| | table : kisiler name surname points ----- -------- ---- ali elli 1 ali elli 5 ali elli 5 veli kollu 3 veli kollu 4 adem bacakli 2 ali elli 4 veli kollu 5 Q ; how can i get result has been showed below; ali elli 15 veli kollu 12 … |
| | Hello, I'm a novice at microsoft access and I'm trying to make a validation rule to limit what can be entered in a field for hours worked. I set the field size to decimal. I set it up to have 2 digits to the right and left of the decimal …  |
| | Hello, I'm a novice at [URL="http://www.daniweb.com/techtalkforums/thread67883.html#"]microsoft[/URL] access and I'm trying to make a validation rule to limit what can be entered in a field for hours worked. I set the field size to decimal. I set it up to have 2 digits to the right and left of the decimal … |
| | I have been using a program that I wrote years ago. It is an Excel sheet that collects data from a MS Access database using queries. Everything was fine until this year (2007) My old queries work but none of my new ones.So I made a copy of and old … |
| | I get a "too many indices" message when I try to access a sequel table via MS Access. Is there a work around for this.:rolleyes: |
| | I ahve a client that exports an mdb file to a server folder from Access and their website auto updates with this information, it there a way to expot a file from FM8.5 that will do the same? TIA mac |
| | :cheesy: Help... I am not exactly a novice, but I am. I have been secured to develop an Access database for a very small organization. There are a total of 13 members who will be updating and pulling reports from this DB, so I am not overly concerned about heavy … |
| | Hi! I am creating a database for a class. It is supposed manage the hospitals Drug inventory as well as the patient's information and what patient is on what drug. I created a drug table (with drug_id, num_in_stock, and num_prescribed) and a patient table (with patient_id, name.. blah blah blah) …  |
| | I have a very simple table in "MS Word" (all fields are text fields) and I want to transform it into an "Access" table. How can i do it automatically? Is there any macro or a programm code that would allow me to do it automatically? (In the future I … |
| | I'm new to FileMaker Pro and am very very puzzled. The words E-Mail Campaign Manager suggested it would have powerful tooks to send e-mails. However, my staff seem to be unable to find a way to sort e.g., for all "journalists" in "Taiwan", and then send emails to all the … |
| | Hi, how can i display images in a form in Ms Access 2003. I have fields in a table and path of images. Thanks |
| | Hi Folks, I'm trying to pass a string between two different forms in ACCESS with code, and I'm having some difficulty tracking down the proper way to do this. Assistance in completing this task is greatly appreciated.. Thanks in advance! - Jordan Here's what I want to accomplish: [B]Form 1: … |
| | I'm try to let a form have a drop down bar (linking to a field in a table) which when any name within it is click it will display on the report that area |
| | Hey all, I'm using Access in conjunction with C# and ASP.net 2.0. I can't get the following query to work in Access, and I have no idea why it's throwing a syntax error. Any help would be appreciated. Thanks! [code]SELECT a.name, a.origDate, b.firstName, b.lastName, c.priority FROM afmMain AS a INNER … |
| | Hey all, i am new to these forums and was wondering if anyone could offer some advice/help Currenlty we have MS Access databse which was created well before i started, this database has all our work instructions mixed into it. Unfortunately it isn't the easiest thing to navigate and seeing … |
| | I'm creating an app with an Access database backend, and I seem to have encoutered two problems that I can neither explain nor solve. 1. When I run the app, there is a blank record that I can neither edit nor delete, and I am forced to click to add … |
| | Is there a easy way to import emails from outlook to a access table? I know I can go file, get external data, etc but I am looking for a macro that will do it or some code for a button to do it. Thanks in advance for any suggestions … |
| | Please let me know the code to populate the data from Table to Forms. What's the code for assigning values to Form buttons? |
| | I need help. I need a MS Access Database to submit for my final project in my Database Design class. Does anybody have one they could discuss with me? |
| | We're using Access 2000 and have 9916 entires. I've been told we're limited to 10000 entries. Is it so? If so, can we upgrade to a new Access? Or, must we go to a more sophisticated database? What's a body to do?? |
| | Hi All, I'm trying get access to a Firebird BLOB field. I have linked the input table using ODBC(FB 1.5). I have tried to extract the blob content various ways, so far unsuccessfully. Is there any way I could declare the BLOB_get, BLOB_open FBCLIENT.DLL functions in MSAccess code module? If … |
| | The following SQL results in an "invalid procedure call" message. SELECT ViewtimeHCPick1WRes1.X FROM ViewtimeHCPick1WRes1 where (((ViewtimeHCPick1WRes1.X)>2)); SELECT ViewtimeHCPick1WRes1.X FROM ViewtimeHCPick1WRes1; works fine. ViewtimeHCPick1WRes1 is a query. X is a calculated field that results in a number of format x.y or x. Any suggestions as to why the where clause is … |
| | Hi, I'm trying to use a Do Loop to look at 2 seperate tables. It needs to check the value in one field on the first table. If it finds a "T" it should look to a field in the other table and count down 3 rows. Then it needs … |
| | Dear Guys, I developed one application using Microsoft Access2003, I use to MDB file, one is time_db.mdb and time.mdb and link these two databases. I put my time_db.mdb in the shared folder [URL="file://\\avss-srv"]\\avss-srv[/URL] and install the time.mdb in the client pc. The time.mdb is reading the database from time_db.mdb. When … |
| | Hey All, I have created the following code in my data base. It works correctly except that the email it creates is in the rich text format. I want it to be in plain text format. The default settings in outlook are set to plain text, but my code seems … |
| | Is there any way to use the sendobject command to send a report as a pdf attachment rather than an rtf attachment. I am able to use the print object command and get this to work if I make the acrobat distiller the default printer. This way forces me to … |
The End.