Hi All.
This may be a bit of a strange one, but was wondering if anyone had any ideas.
I would like to create a db which is a bit like the directions bit of multimap.co.uk
As per the attached jpg, i would like a db so I can input a starting box and end box, and it would tell me the shortest distance, longest distance, route via boxes etc.
e.g
Box A as start and Box F as end. Shortest route is via Box D, longest route via boxes B and C etc.
The db would obviously not for measuring distances between boxes!!!....but thought this may explain it.
I have one Access table called plan_location where it contains the following columns: shape_id (number), seqnum (number), xcoord (number) and ycoord(number). The shape_id is a individual number for each planname, the seqnum is the number of points in the plan and the xcoord ycoord indicate the x,y location on the ground.
In the above example, although this is only one plan of thousands, the xcoord/ycoord value for seqnum=0 is not the same as the xcoord/ycoord value found in seqnum=14, thus this indicates an error.
I need to find a way to isolate those shape_id's with the beginning seqnum of 0 that is not the same as the highest seqnum of 14, in this case. The seqnum can range from 0 to any number, depending on the number of points.
If the seqnum of 0's xcoord/ ycoord values to NOT match the highest seqnum's xcoord/ycoord values, I need to find a way to insert the next highest seqnum and add the same xcoord/ycoord values found for seqnum = 0
Not sure what this covers so if someone could point me in the right direction, so I can get started.
I want to do a search of customers through a button on a form with names, and there you get a list of customer that match your criteria. When you click or double click on that customer you get sent to the main form with all the customer details on it.
I am currently working on an sql query to find employees which handled more orders than average in a certain half year. For arguments sake the half year is august-dec1997. I will use two queries, one to calculate COUNT and one for the avg:
So far I have the COUNT query sorted:
SELECT Employees.EmployeeID, Count(Orders.EmployeeID) AS CountOfOrders FROM Employees, Orders WHERE (((Employees.EmployeeID)=[Orders].[EmployeeID])) GROUP BY Employees.EmployeeID;
However, I am uncertain how to proceed from here and find the >AVG part of this query. Any help would be appreciated- thankyou :o
To add to this I think the next table should be like this:
SELECT qrycountOfOrders.EmployeeID, Employees.FirstName, Employees.LastName, qrycountOfOrders.CountOfOrders, WHERE FROM qrycountOfOrders, Employees WHERE qrycountOfOrders.EmployeeID = Employees.EmployeeID;
My Access DB is built and works great. All problems that I have seem to revolve around the 2 tables that I link to Excel spreadsheets. The spreadsheets come from downloads. The problems are:
Can't format fields in a linked table. and the download comes unformatted.
Can't make DB Multi-User because the Linked Spreadsheets restrict access to more than one user at a time.
Is it possible (Practical) to build a macro that would access the spreadsheet on a regular basis and import it (Overwriting the previous data in the table) into Access?
I would really appreciate anyone that has a solution. I am ready to pull out the last 3 hairs I have on my head.
Dont use access much but I have basic db dev. skills. That said, here's my dillema:
I have a front desk entry form fro service calls. There is a entry field for customerID. I would like to auto populate f_name, l_name etc... from just entering customerID. I know what I would do in an SQL situation, but how does that transfer over to access? Any help would be great. Thanks.
I have a lot of values that look like this: 0.524, 0.673, and 0.398. I hate to look at these numbers with the zero before the decimal point and would like to find out how to remove them. I know that it's possible in Excel, but I'm not sure of how to do it in Access.
I am working on a database that tracks things for a welding shop. Because of this I am using heights in millimeters and decimal points are necessary. The page I am using is an input form with a subform tied to a specific record. I can under no circumstance get my decimals to stay put in the input form or in the table. I have tried changing to decimal and putting the decimal to two and the precision to five, long integers with decimals to 2. Formatting with #.## so it maintains it in the text box... but nothing has worked. Has anyone run into this problem?
Does anyone know how to force a listbox to display an additional level of accuaracy in a listbox which displays a value based on an expression in a querry? My querry displays the value to 4 decimal point but my listbox only diplays the value to 2 decimal point. Thanks!
i just had a good talking to. My boss was expecting to show him alot more than I did. Please help me if you can.
I work for a hard drive company. Harddrives are divided up into categories and sub categories. The highest level is "Family." Next is "Model Number," then the lowest is "Product Number." All of these are included in each of the worksheets and they all have different heading names.
The hard drives are stored in many different warehouses that are potentially in 3 different regions (AMERICAS, ASIA, EUROPE)
I am concerned with three excel worksheets that contain all or some of the fields listed above. The different worksheets represent different states of the hard drive: "InTransit" "Customer Shipments" and "Inter Company Shipments"
The goal is to consolidate all of this information into one worksheet.
The other 3 Worksheets represent the data I am pulling from. Ive written a module in access to import all of the excel files into their own individual tables. I've also written some queries to pull the info i need, im stumped though, I'm feeling like I should wipe the slate and start from scratch. What is the best way to go about this?
I have a table with the numbers formatted as example 9999,99. My mysql database i'm exporting to uses the point as decimal sign. Can I change my query so it outputs the decimal sign as point instaed of a comma?
In my international setting decimal is a comma and should stay a comma.
I have a form in access that opens to the first record every time. This form will be constantly updated and i was wondering how i can set it, so that it opens up to a new record everytime you open the form.
ok.. this is not a hugely important issue, however.. it is a slight annoyance that i would like to resolve if it is possible..most of my currencies will be whole numbers like twenty pounds or five pounds..so i chose to set the decimal point to 0 which displays it like this..£50which is better then setting it on auto (£50.00) which my user does not like..(uneccessary zeros)however.. every now and then there will be a carpark cost of £2.30..if i set the decimal point to 0 then £2.30 will display as £2 which is no good.. if i set the decimal point to 1 then it will display it as £2.3 which is no good..so is there a way to make sure that all currencies display as decimal point 0 values.. eg £34.. £2.. £145 and if a price happens to involve some pence.. such as two pounds 30 pence.. then display it as £2.30 or £103.55... etc....i hope that is clear
Feel free to pick on me. I can't get syntax right. Ever. So when I can't figure it out I just try to find an example of what I want to do and use it as a guide. But I've not been able to find a single example (and I looked at a lot of threads and the *shudder* help files) of using "OR" in a DSum within a single field. Here is a simplified version of my statement:
=DSum("[Contribution_Amount]","tbl_CONTRIBUTION","[Employee_ID] =" & Forms!frmNew_Contribution!Employee_ID & " and [Special_Case] Is Null")
This works perfectly. I want it to look like this:
=DSum("[Contribution_Amount]","tbl_CONTRIBUTION","[Employee_ID] =" & Forms!frmNew_Contribution!Employee_ID & " and [Special_Case] = 'stringABC' or Is Null")
But this errors. And I've tried every combination of ' " () & # I can think of and everything errors, unless I completely set the OR apart into a new criteria, in which case it executes but produces results that are not what I'm trying to get. It also works if I add "= 'stringABC'" and remove the IsNull. I just can't seem to have both. Does anyone know how to write this properly?
I have separated my application logic (forms, VBA code, queries) from my data and am unable to open my form. The form is in file DbAppl.mdb and the table is in file DbData.mdb. Any ideas? Thanks.
My .mdb file was getting too large (500+ mb) and taking a long time to compress, so I separated my application logic (forms, modules, queries) from my data (tables) and now I'm unable to open my form because it can't find the table it's based on. The form is in file DbAppl.mdb and the table is in file DbData.mdb. I thought I could point my form in the one mdb file to the table in another by putting ME.RecordSource = C:xxxDbData.mdb in the Open Form event, but I can't seem to get it working.
I am new in this and would appreciate any help. Here is what i have to do.Have 2 tables ,employees and equipment. People form table1 are signing for equipment from table2.After certain time they turn that equipment and some1 else is getting it. Should i make 3rd table with only signin and signout dates or something else?
Background: I have the foloowing tables tblClient: ClientID (PK) ClientName other client details
tblMachine: MachineID (pk) SerialNumber ClientID (fk to tblClient) other machine details
tblProduct ProductID (PK) ProductName
tblReadout: year_date month_date(pk fld1) day_date(pk fld2) ProductID(fk to tblProduct) MachineID(fk to tblMachine) ReadoutAmount
Question: I would like to build some kind of a form where the user will be able to enter data for readouts (ProductID, MachineID, readoutAmount, year_date, month_date, day_date), but I would like them to only be able to do that, I mean I do not want them to be able to modify any of the other data in the table or even see it, so only adding a record that is it. Also I would like them to be able to enter the ProductName instead of ProductID , how do I go around that ?
I made a form (My_form) with subform (sub_form) and when open main form cursor is in the first (tab = 0) field of the main form, but I want that it is in the first (or desired - for example Name) field of the new record of subform .
