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 … |
The End.