1,557 Topics
 | |
| | 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 … |
The End.