Search results

String = Line... I know most of my stuff from self taught info. Which means alot of what I use to describe can sometimes be wrong, I apologize. And yes, that is exactly what I'm looking for, just to have the points connected by lines to show travel over time through each station. And yes...

Excellent reply. The data plots can easily be over 12,000. I noticed data poins would drop, especially during the busy times in the day, where I would actually not even have 2 ~ 3 entire sets plotted on the screen. The possible number of points I can recieve is quite large, and is only on a...

The BIG problem is this. I need a basic string graph over time recieved from a cross tab query. The data points all come in fine, but the "strings" / lines connecting the points do not show up. I believe the reason is because there are just too many records. I culled the data down using a...

Sorry, my browser crapped out... To finish off, what might be wisest to solve the "line up issue" of a month by month situation would be to then, on the main form, create a query that would end up display each month and year. (If you want just a monthly comparison). Link the subforms to the...

Create 2 reports, one for each query. The easy way to do this is to basically make one, make it HALF the size of the page (since you want them side by side) and design it EXACTLY how you want it to look / feel / etc. When you have one done, copy and paste it, rename it. Now go to the one you...

If the text was 10s to 20s of entries long, then yes. But when a text is only 3 to 5 letters long.. and 50,000 wouldn't have all the same text.. it would have one of 4 possible... and 4 possible is a smallish look up table. Kelemit And you are right, space-wise. Largish options would...

Anyone have anything for this? Why Access has problem showing all the data points and lines but Excel doesn't? Kelemit

to which? The look up table? and thus have another Drop down menu list? And what if you one of the options from you lookup table is now defunct / old / no longer used. You cannot remove it from the look up table, to do so will make your data on the main table useless. You must now add a way...

Possibly, unless you have a lookup table that you wish to edit over time / change. in which case, your numbers will now be pointless because the data in your table is a number and the data in you lookup table is gone... Or you don't delete it, but can't keep other people from still picking it...

You may be right, then again... Her point is that the table is recording the number associated with the field lookup. On the form, the lookup table is returning both fields, but hides one and is bound to the field recording the number. This is what I'm assuming because she states its showing...

If I remember correctly, if you format the box / label to appear / dissappear, that will format for that box across ALL records. It will turn them ALL off or ALL on on ALL records. It will work great if you only return ONE record, but when you are making a list of records, it won't. Same...

IF you go to the table where the data is at.. does the status come out as a number as well? In that case, what you have stored in the table is the number, and the status table probably has two columns, one the number you're getting, and the other the "description" you WANT to get. The best way...

With ctrl If TypeOf ctrl Is TextBox Then If StrComp(.Name, strFieldName, vbTextCompare) = 0 Then FieldExists = True End If ' Select Case .ControlType ' Case acCheckBox, acTextBox, acListBox, acComboBox ' If...

2 options that I can think of... sorta. or 3, 2 are variations of each other. Create 2 queries, returning min and max of the dates for the complaints you're getting. Make 2 text boxes with control source = to those queries, formating the box to be MM,YYYY. If teh query is too complicated to...

Go into the properties of your combo box. Look under "Data" tab. Find "Bound Column" Change to I"M ASSUMING 2. That number needs to be whichever column that "price" is in. IE: Look at your record source field for that combo box, click on the ... box next to it, and see how many columns...

Staff table: Staff ID (Primary Key) Staff Name Staff *** (Any other fields you want) Staff Currently Hired (Yes/No) Task Table Staff ID Task ID (Not necessary as currently described) (Primary Key) Task Name Task Description Task Read Link Staff.StaffID to Task.StaffID. It...

This is a question in 2 parts: First off, since i'm new, I'll introduce myself. I'm a self taugh Access database designer. Lets just say that the first stuff I started off with was very embarrasing :D But i have alot of programming background. I have been with access a while now and now...