3,842 Topics
 | |
| | Hi there. I'm looking for a bit of advice. I have a lookup table (tlkOrganisations) which has only one field (apart from the ID) and it list orgnisations. I'm using this for a field within a form so that I can use it as a lookup combo. The advice I'm … |
| | Hi, I wondered if I should set "replication ID" for field size for the foreign key? The field size is courently set to "long integer". What is bether to use, why and what is the difference? Thx for your help.  |
| | I would like help with MS access iif statement. I want to group courses but day offered e.g Monday, Tuesday, Wednesday, etc and by time offered e.g Monday: 6:00 PM - 9:20 PM. I have an iif statement which should convert the letter (day) to worrd e.g, M to Monday … |
| | hi all! I need to set precision to the left of decimal. For the number field i have to set the field precision such that the nos should be in a format as 0001,0002,0003------------------.9999. Thanks  |
| | Hi, I have a parameter queery which asks for "Name " . I want to Enter a few characters and find similiar full names to it which are in the field "Names". For example: If I type chr it should find out "christine" Pleae help Best regards Nadeem |
| | [code]Set rstDeps = CurrentDb.OpenRecordset("SELECT Members.OrgID, Members.ID, Members.Member, Members.PrimaryRep, Members.MembershipType " _ & "FROM Members " _ & "WHERE (Members.Member=True AND Members.OrgID=" & !OrgID & " AND Members.MembershipType='" & !MembershipType & "');")[/code] This is my query in VBA in MSAccess. I just want the number of people that fall into those … |
| | I am a new user of FileMaker Pro. I am converting an MS Access database and am stuck on including multiple tables in a format. How is this done? |
| | I have stored procedure in MS SQL and I want to deliver value from form (value of textbox) in MS ACCESS. CREATE PROCEDURE sp_DeleteOwing @OwingID int AS INSERT INTO Arhive SELECT MemberID, ArticalID, OwingDate, GETDATE() FROM Owings WHERE OwingsID = @OwingID DELETE Owings WHERE OwingsID = @OwingID GO I tryed … |
| | Has any body used the Professional suite of products for FileMaker released by FusionCharts Team? [B]FusionCharts Pro for FileMaker[/B] is the FileMaker charting tool and [B]FusionMaps Pro for FileMaker[/B] is used to create flash maps within FileMaker solutions. As both the products use built-in features of FileMaker; people having knowledge … |
| | I have database in MS SQL Server 2000 and I want to connect to this database from empty database in MS Access because I want to build user interface to that database and also call procedure and functions in VBA. Can someone tell me how to do this or tell … |
| | hi Friends! i need to open a pdf documents from MsAccess. Please send me the code. Then i need to create a BROWSE button such that BROWSE_BUTTON Text_box When i click the browse button it should work as ordinary windows browse button and when i select some files, the "File-Path" … |
| | Hello please help me to calculate this one: I have a table containing this fields (name, project done, hours consumed) example: this is a table of a timesheet [code] [COLOR=green][LIST=1] [*]--------------------------------------------------------------------------- [*]| NAME | PROJECT DONE | HOURS CONSUMED | [*]-------------------------------------------------------------------------- [*]| A | 1 | 5 | [*]| B … |
| | I am tryig to match records from a query in access to records stored in a table. I have a littel problem which i am trying to solve? Table1 -manufacturer -model (primary key) -picture Table2 -Deal -price Query1 -Model (this is in a query as it has been split from … |
 | hi, i am great at php but completly new to microsoft access databases, could someone explain simply how to make one, or give me a link to a site which explains plz???  |
| | he y pls any one help meee in linking html with ms access.... i have noo idea about how to link html with ms access....  |
| | I have 2 problems I need your help please: 1- How can I map the result of a select query? let's say that I have a table named "Item" and I need to delete a specific item record from this table. So the user first needs to see the information …  |
| | I'm trying to keep a date in a subform. Once the user enters a date and the procedure done on that date, he clicks on Add Record button and all the fields in the sub form are blanked out. I need the date to stay the same so the user … |
| | I want to share a resource with all the FileMaker users and I am sure that this will help us professionally. FusionCharts Free for FileMaker has been released. This helps to create data-driven flash charts inside FileMaker solutions without installing any external plugins, drivers or server software. Since it uses … |
| | Hiz people ....after a day i m having pracitcal exma....n they have said me to make a database....so i decided to make student database of my school.....very simple so that sir wont ask me hard questions....so plz i think i donno some steps in completing my database....can anyone help.... for … |
| | I am working in ms access database2000 and my frontend is vb 6.0. I have three tables namely:- AREA:- areaid,areaname ROUTE:-routeid,routeno,routename,areaids PARTY:-partyid,lastname,firstname,address,areaid The field areaids in ROUTE table consists of chain of areaids belonging to that particular route in this format '12,23,65,67,' The problem is that i want to derive …  |
| | Hi, I'm creating a customer database in MS ACCESS with the following 3 tables: Customer (with unique customer_id) Products (with unique product_id) Customer_Order(contains both customer_id and product_id). I want to be able to use a form to enter new information into both the customer table and the customer_order table. The … |
| | I am supposed to create a hotel reservation system that allows you to make a reservation either with a hotel package or without and calculate billing. However I am at lost for where to begin. I have made a couple of sorry attempts but I am having problems identifyind the … |
| | How do I limt the records extracted from filemaker using the query "Select.... LIMIT 5" ? Example: select * from tablename limit 10. I connect the filemaker pro 8.5 via ODBC and use php to display the records.A small amount of records(1 or 2 rows) will display the records, but … |
| | I have a simple form that I want to have generate a random password, I just need it to generate the password, The database user will then copy the password and paste it where she needs it. The main issue I don't want her to have go to a web … |
| | i would like to query a date which only showing work week and year... i try in FORMAT([MYDATE], 'WW YYYY', 1, 2)... it work but when goes to 31/12/2006 it showing "01 2006"... but suppose it should show "01 2007" how can i overcome this? |
 | I really need some help here and hope there are some Access database whizzes out there...and i know...there are.... my friend and I are doing a database project for a health care service... and we are trying to use the expression builder to perform calculations But for our fields, we … |
| | hello im preparing a chemical database where i need to store chemical structures. ASP as front end i want that when the user draw a structure(user will manually draw the structure) in frontend there should be a search in the database for similar structures and all the similar structures should … |
| | I am done wracking my brain on this one, so if anyone has an answer I would be most grateful! I am trying to format a form in Access where users could check off a box and have the home address (already enetered on another subform) auto-filled in the fields … |
| | Hi - I am using Access 2002 (Office XP) I am trying to design a database to use in my business. I have created the following tables: Suppliers, Products, Salespersons, Locations(where the products are sold). I now want to input sales info. I need to input Daily Sales for each … |
| | hi i don`t know if this is the right forum for this but its an emergency.... does anyone know how to add pictures to MS Access database!! like, to add a column called pictures and under that column we have all the pictures displayed!!! plz HELP |
The End.