Search results

Just bumping to see if anyone has any idea on this one.

I've been having an ongoing issue with a number of graphs in my database. Basically the problem is that the chart is not displaying the same data as the query that generates it. I can go into MS Chart by double clicking the graph and when I look at the X-variable data in the table there it...

Honestly that seems kind of backwards. The normal flow of design would be that the record you select in your main form should open the record in the subform (linked if they are both bound, which makes it super easy.) But if for whatever reason you have to do it that way, I would suggest that...

I have some texboxes (read from a datasheet) that have some problems with the decimal format. The field "Density" is shown in a form and a report. In the form I selected the format as "Fixed" and Decimal = 3, and got the number I wanted. In the report I did the same, selected the format as...

That's either due to the forms not being bound to some table, or its caused by a remarkably frustrating bug that seems to have existed throughout time for access. Anyways, if it's the bug you simply have to type the field name you are linking through into the master and child sections. The...

I have a report that contains a subreport. The main report has 2 graphs, and the subreport also has 2 graphs (usually with 2 records, so 4 graphs). That gives me ~6 graphs, with ~1-5k datapoints per graph. Now, I am having some....issues....with the report, and I think it's due to the amount...

ok, found one candidate for the error. I changed: LookIn:=xlValues, lookat:=xlWhole to LookIn:= Excel.xlValues, lookat:= Excel.xlWhole but that still didn't fix it

I have a function that isn't working properly and I can't figure out why here is where it's called: ... Dim xlMDSheetRaw As Excel.Worksheet Dim Datastop As Long ... Datastop = FindOne(2, xlMDSheetRaw) ... Function FindOne(Start As Long, ByRef xlSheet As Excel.Worksheet) As Long...

I just got in the habit a while ago of not spelling any common words with the normal spelling. The amount of times that a field named "Date" has hosed me has made me a little circumspect.

how did sec get set as a variant? I thought it was declared as an integer in the top thing. Or is that method of dimming not settnig them all as integers? edit: haha oh wow I just checked that and what a stupid mistake to make! I think I saw that in some code somewhere and I was like "oh man...

ok....I have a suspcion that this has to do with me explicitly calling the ExportRecordsetToExcel sub when I am passing something to it byref....but I'm not sure. grrrrr edit: yeah that didn't fix it. oh well

I'm getting a byref type mismatch in some code and can't figure it out: The bolded part is what's throwing the type mismatch, specifically the "Sec" variable. Its highlighted by the debugger when the mismatch is thrown, but to be honest I think it's the "xlbook" variable throwing the mismatch...

I've been :banghead:about a chart that I'm having problems with. It's within a subform and displays the correct data, but it needs some formatting (because default formatting is 99% of the time awful). The first formatting changes I put in worked fine, saved the form, reoppened it and it's...

This is driving me nuts, and the main reason is that I had a working solution at some point but then I went and deleted it :banghead: Here's the problem. I have 2 markers I need to format on a chart. The first needs to be a filled black square, no line. No biggie: With MyNewSrs...

This is driving me up the wall. I know I've had this problem before, and I know that (somehow) I fixed it, but I have no idea how. I have a pivot chart in a form in my database, and it needs some formatting changes: - X-Axis needs tick marks/labes spread out to 10 spots, default is 1 (which...

F11 didn't work, but this did. Really saved my butt, thanks much. Now I just need to put something in that will sort this on its own.

I have a front end where the path to the backend has changed. Should be easy to fix. Except that now when I open the database it crashes out of Access. I get a series of "Object not found" or "Invalid Database Object Reference" errors in a row and then I get to a crashed macro from the...

I'm adding a little duct tape to my split design and trying to maintain a simple persistent connection that opens and closes with the switchboard, and I think I've got it working but I want to make sure I'm not doing something completely moronic. I appreciate that in terms of style there are...

Ah ok, yeah that's along the lines of what I did for the integration query. Its an ugly little piece of sql.

I have a table of records that shows a series of events. Each record represents 1 event with 1 date given to it. I need to know the time between that event and the event that occured directly before it. So like record 1 would be 1/1/2001. Record 2 would be 1/5/2001. Record 3 would be...