Search results

Did you compile the vb code (Option under Debug menu in the vb code window). I think thats happened to me when I hadn't compliled in the past?? Until you compile it, vb doesn't know its there, even if you save the code, it can't run it. Normajean

I think I finally get it now! Hi Pat: I assumed that the subforms would behave like subreports, and must have set every property in the form, subform I could think of to try to 'correct' the subform's stubborn size. Now that I know, I have changed the design of my form/subform and am glad that...

I now understand! Dear FoFa, pdx_man, RV and Pat Hartman: Thank you for helping me out on this! I really learned alot about database storage from your posts; although I tried to seach the web, I couldn't seem to locate the information I was looking for. So glad to have this Forum! Re: the...

Yikes! Is that true?? Wow! This seems like such a limitation! I'm used to using sub-reports quite a bit, and they are so nice because they grow and shrink as needed. The problem with this subform is that there can be from 1 to 50 visits, (usually only a couple) and I wanted to follow the...

Hi: I don't know why I can't get my subform data to show? The unbound subform is on a Pop-up form that gets opened when the user clicks on any patient record in the MainForm. The subform on the Pop-up is supposed to show all the patient visits for that patient. When I view the subform on its...

Hi Rich: Glad it helped you out. You know you might want to change the function to return an integer with the actual ordinal position (1....n) - instead of a string with 'Yes' or 'No', and then change your final query's criteria for that field to 'between 1 and 5' I had it that way at first...

Few comments and ideas Hi yessir! Well looks like your problem might be that the names in the "Where" statement you are putting together don't match the table field names. You are using the names of the form fields, but the sql statement is looking at the table. So change the parsing of the...

Hey Rich_Lovina: Here is a zipped up 2000 Access database (SampleTop5.zip) that has a solution to your problem. I've had to do these myself, and the cleanest way I found was to create a Temp table from a Make table query, where the last column is created by calling a function (which I've...

Hey PDX_Hombre! Yes, you are correct; my Pass-Through query is just doing the SELECT from the HUGE tables, then I create another querydef, assign the querydef.sql = 'Insert into NEWTABLE select * from qryPassThrough', and run that query. The 'Insert Into' creates the new table, and doesn't mind...

OOPS! Forgot to include in my last post: I tried using the CONVERT in my passthrough SQL query Select list to specify that I only wanted it to return a char(5) for one of the text fields, but the Insert Into still created a text 255 field for the item in the table. I thought of that also, but...

Hi PDX Man! I am creating the table in the local Access database. The source of the 'select into' is a querydef that I build just prior to the 'Select into'. The querydef is a pass-through that pulls data from multiple HUGE tables over a network (performance issues are why I create a...

The table name has a "/" in it. If you remove the special character from the name of the table (and also remove it from the 'Select' statement in your event code), you won't get the error anymore. Normajean :-)

Just replied, and don't know why a smily face was substitued in place of the ending parenthesis prior to query 1 nametag 'A' and prior to query 2 nametag 'B' - Please substitute an ending parens for these. Normajean

Hi: Hope this will help; it looked to me like both subqueries in your question were Identical! It sounded from your description that what you were looking for in the second query was a total of all records, so I just took the 'Group By' out of the second query, so you would get a total count...

Hi there: I have a fairly wide form (more fields than will fit into the screen width), so you have to scroll over to the right to see the righthand fields. If I scroll over to the right, based on the value in those fields, I see a range of records I want to select (and I want to do the selection...

Hi: I am creating a temp table in an Access 2000 database (from a pass-through SQL query). Its all working groovy, except that all my text fields are 255 characters. Is there a way to specify the length for various Text fields created with the 'Select into' statement (without having to go...

At least I think it should be easy, but I can't find an answer in books or on the web. The purpose of the query is to create a temporary local Access table using a passthrough to a SQL database. (based on user login). #1: My application first creates a SQL pass-through, then a make-table...

Thanks autoeng and Pat! Really appreciate the ideas and design advice. Normajean :-)

Hi: Not sure if this will help, but here is a snippet of code that I used to check to see if items were selected in a multi-select list control. I only proceeded with my process if at least one item had been selected from the list. You could easily change the sub so that it checks whether or...

Hi: I'm not sure if this is applicable to what you are doing, but I had an application where I matched boats with multiple boat parts. (Table Parts_Boats basically had two fields that held related pairs). I had a multi-select list of boat parts (list control named 'Parts') and the user could...