1,597 Topics

Member Avatar for
Member Avatar for hdhere

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 …

0
81
Member Avatar for stealthdevil

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 …

Member Avatar for stealthdevil
0
108
Member Avatar for jlopez

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 …

0
67
Member Avatar for Stick

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 …

0
77
Member Avatar for Stick

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 …

0
76
Member Avatar for cpeck

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 …

0
59
Member Avatar for bacgmc

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 …

0
61
Member Avatar for zachary
Member Avatar for nixlie

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 …

0
75
Member Avatar for rosy99

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 …

Member Avatar for rosy99
0
117
Member Avatar for sprocket

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 …

Member Avatar for madmital
0
73
Member Avatar for jto

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 …

Member Avatar for DEARDEVANG
0
163
Member Avatar for ChinDave

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 …

Member Avatar for Comatose
0
316
Member Avatar for musicmancanora4

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 …

0
72
Member Avatar for khwo

[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 …

Member Avatar for pty
0
103
Member Avatar for AndrewHolness

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 …

0
114
Member Avatar for Saundra

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 …

Member Avatar for yvs
0
320
Member Avatar for svarghe

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

Member Avatar for MerryOtter
0
325
Member Avatar for leba

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 …

Member Avatar for leba
0
454
Member Avatar for builderbob

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 …

0
77
Member Avatar for boristhemoggy

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?

0
130
Member Avatar for jayjay21us

[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] …

0
96
Member Avatar for hhassey

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 …

Member Avatar for aniseed
0
79
Member Avatar for PoisonedDoxy

what are all the different types of data checks you can use in database tables such as field length check and range check

0
111
Member Avatar for Mandoos@2006

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

Member Avatar for Mandoos@2006
0
106
Member Avatar for silent1643

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 …

0
68
Member Avatar for silverspring

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 …

Member Avatar for campkev
0
113
Member Avatar for gonzaloju

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 …

0
76
Member Avatar for JC_2000

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 …

Member Avatar for JC_2000
0
236
Member Avatar for kennygee

[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 …

Member Avatar for kennygee
0
78
Member Avatar for djbsabkcb

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.

Member Avatar for spycee
0
130
Member Avatar for rmccaslin

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 …

0
73
Member Avatar for Jeewai

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 …

0
73
Member Avatar for roychong

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

0
82
Member Avatar for Mareq

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, …

Member Avatar for benyam_dessu
0
182
Member Avatar for benyam_dessu

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, …

0
58
Member Avatar for syncdigital

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 ? …

Member Avatar for campkev
0
131
Member Avatar for roychong

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 …

0
113
Member Avatar for YoTaMiX

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" …

0
91
Member Avatar for jayboi2005

[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 …

Member Avatar for pker walker
0
267
Member Avatar for pker walker

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 …

Member Avatar for Kegtapper
0
102
Member Avatar for Melotron

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 …

0
108
Member Avatar for mxcsquared

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

Member Avatar for Edward Kinlen
0
81
Member Avatar for ALAN SMITH

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

0
74
Member Avatar for policy10

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 …

0
79
Member Avatar for ambiguus

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 …

0
61
Member Avatar for TKSS

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 …

0
155
Member Avatar for hopkins1878

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.

0
91
Member Avatar for Kakashi

Does any of you know what DBMS products are suitable for internet database system other than Oracle 8[I]i[/I] ? Thank you?

0
65
Member Avatar for sweetpeakate

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 …

Member Avatar for campkev
0
74

The End.