Search results

OK Pat, maybe you can help me, then. My problem with the updatequery is that the updates are based on information that can only be found in another query (MAX of [field]). When I put the SQL together (from the query builder) it won't let the update query execute because it says that it is not...

I want to change the field in all records with certain criteria through code. I have tried DoCmd.RunSQL but I am having some difficulty with the SQL statement. (I have made it with the query builder, but I'll spare you the details for now about what is difficult) I know how to do it with VB...

To let you all know...I spoke too soon. I am still experiencing the same thing. It must be with my Windows set up or something other than Access in particular. Hopefully I will figure it out.

OK, here's what happened (I think). I noticed that I had 2 video cards in my machine. Even though the second one was not enabled (in Windows 98 as a second monitor), it was in the device driver so I removed it. I did a brief test and it looks as though everything is working the way it should...

I spoke with Stream Tech support. They think it has to do with my video card hogging too much space. Pat - I have been thinking about doing that (reading up on libraries) although I'm afraid it would only be a temporary thing. I checked the application on other computers on our network and it...

RAM is not the issue. I have 196MB (up from 128). The issue is that Windows or Access (I'm not sure which) allocates only 64Megs to that area that VB uses (it's called GDI-something) no matter how much is on your machine overall. The only solution I can see is to have Access only open some...

I am constantly running out of memory (RAM) when working with Modules. I posted a few weeks ago and someone sent me to the Access Encyclopedia where it talks about using only the 64 Megs of RAM for Modules no matter how much is installed on your computer. They spoke of the problem that VB loads...

I have a tblFamilys table (with Last Name, Address, etc.) and a tblIndividuals table (with First name and a whole bunch of info specific to each person) that are linked by FamID (primary key to tblFamilys). I can determine by a field in tblIndividuals whether the person is an adult or child and...

I have to admit being a little confused at trying to follow exactly what you are trying to do. However, I'll give you two possibilities to look into. The first (and easier if you are a novice) is using a subform. The subform could be based on tblFunctions and be on frmHeadcount related to...

I want to open a report from a module. Depending on some variables within the module, I want the report to say different things. For example, how do I take a string created in the VB code and use it (write it) in a text box (or label)? Is there a way to create a public variable and then quote...

I want to open a report from a module. Depending on some variables within the module, I want the report to say different things. For example, how do I take a string created in the VB code and use it (write it) in a text box (or label)? Is there a way to create a public variable and then quote...

Thanks for the help. I am having trouble with the download from Microsoft's site. (IE says it can't find it) Would you have a copy of that you could e-mail me? Thanks. Dave

I would really like to use the Tree View ActiveX control on a form. I can not figure out why I can't do it. Is there a place that I could learn how to use it? Do I need something else to make sure I am able to use it (a download or something)? Thanks for any help you have. Dave Shacket

Thank you. That was the solution. (I am still trying to debug this code overall though - so I may post again!)

I tried that. The same thing came up. I am beginning to wonder if there is something in References that I have to change. Any more help would be terrific! Dave

I need to use the Left function (to get the left part of a string) but I need to tell it the length dynamically. VB help says that it merely needs to be an expression that produces a number. Here is what I have: Public NumberLet As Variant 'I have tried 'Long' as well - this is declared at...

Ian, Thanks for your suggestion. Here are two variables I was not clear on: 1. All of the people are in the same table. What I DO have already done is the query stating which "circle" they are in (i.e. "1" for the top guy, "2" for the 7 in his group, "3" for the 49 in their groups, etc.) 2...

We have a database and will have a "top" person who will have 7 people in his group. Each of his 7 will have 7 in theirs and so on. I want to print a report that would show the groups as you would see the folders listed on a hard drive, or a family tree, or flow chart, etc. Any ideas? (I have...