Search results

I've got my default format as 2000. Which I'd like to keep for a little while as not everyone in the company is upgraded yet.

Hello, I've been using MDE files for quite sometime and just recently the network guru upgraded me from 2k to XP. Now when I go to create an MDE file the option is disabled. Anyone know why this would happen? Thanks

When you switch a query to an append query it prompts for the table as well as a data source. That's where you can specify the file.

What I usually do in this situation is create a module variable to store the value of the parameter and then a public property to retrieve the value. Then you can set the query for the report to filter based on the variable's value.

The only way I know to write to a text file in access is to use the streamwriter.

It'll work but we'll have to work through a few things together. First, you need to add a reference to DAO. In the visual basic editor click on Tools, then References and choose Microsoft DAO... The highest version you got. Also, copy and paste the exact code you wrote out.

How do you mean linked? Do you mean you can open the 2nd form from the first with it located at the same company record as the 1st?

The uses for recordsets is unlimited. I use them quite frequently. But I can understand you questioning them as I did in the beginning. The recordsetclone property I've only used for searching records. I do use recordsets for loops a lot though.

Dim rs1 as DAO.Recordset, rs2 as DAO.Recordset dim i as integer Set rs1 = CurrentDb.OpenRecordset("Table1Name",dbopensnapshot) Set rs2 = CurrentDb.OpenRecordset("Table2Name",dbopendynaset) rs1.MoveFirst Do Until rs1.EOF For i = 1 to rs1.Field("IntFieldName") rs2.Add rs2.Field(1) = ...

Thanks Quest4! That was describing exactly what I was trying to.

sFreeman is right in that you need a junction table. Looks like your third one is setup for that. In that case you need to create a relationship between the Cust# in Customer and Uses table and then another relationship between Car and Uses on Reg#. A many-to-many relationship is an arbitrary...

I've gotten this error before and haven't totally figured out what causes it. I would recommend reseting your references to dll's and libraries.

No, what I was doing was on open of the form set a module variable to an instance of a class I created. The only time I use the Set statement again is on close of the form to set it to nothing. But I have events that call certain methods from this class while the form is open and sometimes I...

Right at the moment I'm having a challenge recreating the error. The only place I have code set the variable to nothing is on close of the form. But users seem to be getting the message that it's not set to anything before they're closing it.

I was under the understanding that a module level variable exists until you change it or the application closes. I haven't stepped through the code because I don't know when this is occuring. I didn't write any code to make it equal nothing. Basically I have a module variable that is an...

Well that's not exactly what I mean. Basically, I've got a variable that's set to an object when the form opens and I want it to remain assigned to that object. I don't have any procedure that sets it to nothing. But sometimes when a prodecure is called that is suppose to use that variable I...

This is a rewording of a post I created a few hours ago. I have some module level variables that seem to be losing their value when I don't want them to. I noticed it happening when I opened another form in dialog mode. What would cause these variables to lose their value? I thought their...

Does anyone know what would cause a module level variable to lose it's value while an application is in use?

No problem. Are you familiar with building strings? It's a good skill to have in development. Take for example the line of code below: Me.Filter = "State = 'NY'" You're passing a string to the filter property of the form which it then compiles to figure out what to filter. You can do all...

One place to look up filters is access help. Also look up SQL. But here's a rundown on basic filters. It's the Where clause of SQL without the Where word inserted. So say you want to filter by a certain state: State='NY' In your code you'd need to surround that entire line with double...