Search results for query: *

Will try within the next week or so and post how this works. Thanks CautionMP. Thank you for your help. Tammy

I have a database that I have class objects in the project viewer but no object associated with it. Does anyone know how to delete the class objects? I tried to create forms. They didn't create, but apparently in the code windows they did. Now everything is corrupt. Thank you for your help...

cmmrfrds, thanks for the input. Yeah, your idea was and is what I am going to do now that I find that there is no way to do what I was planning. By saying "I've never seen a case/example in vba where you can lay multiple defintions on a give storage area like with lower level...

Thank you for that input vbajock. As for your question, what I am doing is I have a file with 15 record types. The first 3 characters of each record indicate which record type it is. Each record type has a different layout. I was trying to figure out a way to read in a line and assign it to...

LittleSmudge, sorry that doesn't help. Yes it would end up as you said (I messed up with the string, an 8 character Header Date should be 12062003). I don't understand why it gives me a "preety clear idea about why you can't do it". rdodge, what I am trying to do is read in a line...

Tried both. In the procedure I get an error that I can't do it. At the top of the module, I get the following error: "Only user-defined types defined in public object modules can be coerced to or from a variant or passed to late-bound functions". It is 11:30 here and I am going to...

I have posted a question about user-defined types and I want to address the question a different way so I am submitting this post. If I declare a user-defined type like follows: Public Type Input_Header RecType As String * 3 HeaderDate As String * 8 FileName As String * 44...

vbajock. Thanks for all your help and ideas. Unfortunately, this has not solved the problem. I am still unable to assign the variant to the new datatype. I still get the same error. I have tried to declare the type at the top of the module, in a module where all my global variables are...

Maybe it will help if I describe what I am trying to do this way. I want to create record descriptions as types. I would then read a line of a file in, evaluate the beginning of the line to determine which record type it is and then assign it to the appropriate type. For example, you know how...

I read the links, but I am still a little confused. I have the following that I got from somewhere else but I didn't really understand how it was different from what I was doing. I guess this is early binding. After declaring the file, how do I open and use it? Dim fso As New...

Not sure I understand your question, but it is a code module. I will probably have a form that executes the code but the purpose of the code is to import various record types into different tables while doing error checking. Thank you for your help. Tammy

Okay, I am fairly good at the basics of VBA and Access but I learned it on my own. I never took a VB class or any other OO class. Therefore, sometimes the terminology stumps me. I am trying to create a user-defined type: Public Type Input_Header RecType As String * 3 HeaderDate...

I need to import a text file. There are 15 line types and therefore 15 different formats for the lines. The formats for the lines are fixed width. I believe the type statment can be used to define each line type and to read each line into the appropriate type. Does anyone know how to use the...

Something has bothered me for quite a while and I have just decided to see if anyone knows how to fix it. You know when you set the scroll bars property on forms to neither how it keeps a gray space on the form. When you have a form with a different color background this does not look nice...

I submitted this last night and there is no response yet so I am replying to the thread to get it to the top of the list to see if I can get a response. Thanks. Thank you for your help. Tammy

I don't care for the Navigation Buttons at the botton of a Form. Therefore, I want to remove the buttons, but I like the count of # of records. In a report you can do a running sum to see what record you are on (there are other functions for the running sum of course, but this is how I usually...

Does anyone know anything about the setpermissions property in Access or anything else that will help my co-worker? I have a co-worker who has a procedure where he deletes and recreates a table. When he deletes the table the permissions that go with that table are removed. When he recreates...

Thanks. This is actually what I figured out after I posted this request. I created a public function to assign the value to that function and return it in the query. Thank you for your help. Tammy

Can you reference a global variable as part of criteria in a query? If so, how do you do so? I am trying to do so and it is not working. I tried using expression builder but it does not find the variable. Thank you in advance for your help. Tammy Thank you for your help. Tammy

Thanks for your help. You have answered my question. Unfortunately I am trying to reference another form, not the current form. Thanks again. Tammy Thank you for your help. Tammy