1,597 Topics
![]() | |
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 … | |
I have a subform on an Access form and in some cases default (or auto fill-in) fields in the subform from values in the main form. I don't want to default the values unless the user tabs to the field in the subform. What I've found is that if I … | |
Hey there! Wondering if I might get some help. I have been asked to add some things into a database that we have. I have inserted a subform in a main form, with the correct links, etc. Data will be entered into both the main form and the subform. I … | |
Hey, I need to implement a database using MS Access. I am currently using a java platform and I dont know how to access the information stored in the database. I have used MySQL database in previous programs but it gave me some problems when loading the application. Can anyone … | |
Good day, Iam traying to get result of my record as below If next record is biger than previous show "1" If next record is same previous show "1" If next record is smallest show "0" if next record is same previous show "0" Example: id Time Code Price Res … | |
I have an Access form that runs a search on a query and returns the results to a listbox on the same form. I have two question regarding the search functionality. 1. Is it possible to search for the exact value for instance I have a Movie rating column and … | |
hello , is anybody here who help me in foxpro. for following requirement every week i get a table of some databse from server and i have to modify the structure of that file every time to use that file in some other application ,so i want to make a … | |
Hi, I have an access database that I use for recording the sickness of my employees. One of the tables holds the dates, Start Date, End Date and Count of Days etc. I need to produce a query that will show me a count of all of these dates between … | |
Hey guys just wondering if anybody has any idea how to make some sort of shortcut that will automatically run filemaker pro on the client computer so that it is able to connect to the remote database on the server. Is there a way it can be executed from the … | |
[COLOR=#000000]Anybody can help me in this situation. Now I’m using MS Access to create a system but I need to install the MS Access in every PC that has use the system. So if I put the MS Access in server and then all the user just point to that … | |
I have been trying to get filemaker to give running balances but its impossible. Lets say I have an accoount with the following transactions: OpenBal Deposit Withdrawals ClosingBal Date Rec1 0 10000 0 10000 30 Sept 2005 Rec2 10000 0 5000 5000 31 Oct 2005 Rec3 5000 2000 0 7000 … | |
I have put together a Human Resource database for your company. The HR manager wants me to setup the vacation time field to automatically adjuster it's self each time their vacation changes each year from their Hire Date. My fields are: Date_of_Hire and VTBeginningBalance. Each time their hire date comes … | |
HI Everyone, I have recently joined this site because I cannot find help anywhere online about FileMaker Pro (without a charge, that is). Every month I import about 80 excel files from 1 file folder. In order to do so, I have to individually import each file into my database. … | |
I am trying to do something in Filemaker Pro that I could do easily in Access with a subreport. I have a table with the fields (student ID, subject, course number, course name, grade, CRN, semester, credits). In one section of the report, I want to list all records with … | |
Hey, I am trying to link a form in access to a report. The problem I am having is, the report open fine but I can't get it to display the report specfic to that user displayed on the form. It displays all records, not just the one. I have … | |
Hi, we have an access database, and we want to 'push a buttton' and have it synchronise itself with acopy of the database on a web server. Does anyone know how to achieve this? | |
[COLOR=#555555]I have a table where the user will enter a commencement and ending date and an amount that was charged for the period of time. This is all on a subform, link together by an account number. Also, each record on the subform, may have multiple dates For example:[/COLOR] [COLOR=#555555] … | |
I hope some one can help me!!!! (hopefully) I am trying to import tables from a Sybase database into Acces 2000 but I have no clue on the Vba script that will do the job. because Access does not have a macro recorder I'am having a hard time learning. the … | |
what are all the different types of data checks you can use in database tables such as field length check and range check | |
Hello Message popup everytime log-on to the computer like this: "Error loading p2esocks_1012.dll The specified module could not be found" Would anybody help me to get rid of this please.... Mandoos | |
okay i have downloaded the business template for filemaker pro 8, and have been racking my head all day. I have been able to setup an inventory system for the apparel company i work for complete with the size quanities. My only problem is i can't get the sales order … | |
Hi, I have column with alphanumberic fields like: trader1.dbpt 1234.mcxl abc243.cexl 234-lab.cxcl There are following characteristics of this data: -fifth last place is always decimal -always four characters after the decimal What I want: -only those rows which have ".mcxl" at the end -rows should NOT have numbers in them … | |
Hello, I create a database where students put their names and name of events to sign up. I work for an university and I already creatied the system. My question is, I would like to know how I can make the Forms to be public in order to put them … | |
Hi, I have a composite in a Microsoft Access Database that is not populating, when I add data to the two tables connected to it you would expect the Composite Key to populate as well wouldn't you? But this is not happening, can anyone expalain why and how this problem … | |
[U]Access 97[/U] I am developing a system and am getting the following error on compilation - "Cyclic reference of projects not allowed". The help system advises me to resolve the reference but doesn't say how. The compilation window does not highlight the error in the code and I can't figure … | |
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 … |
The End.