Recent content by joatmofn

When access closes, I need to save the state (form name and screen location) of any forms that were open at the time that access was closed. I'll save the info in a table. The next time the database is opened, the forms that were last used and opened need to be opened. Any help with existing...

I exported some of forms and queries to a separate mdb file and linked them to the backend tables. Then I went to the main mdb file and removed the exported forms and queries. From the main mdb, how do you reference forms and queries that are in a separate database? Thanks

I don't mind that they change the code unique to their project. It's the code that I use to control browsers, etc. that I use in all of my applications. I think the suggestion of a separate mde for my code might be the way to go. I need to do an example to be sure though.

There is no contract.

Yes, that's what we do. The difference now is they want to make code modifications and reports themselves. I just want to protect my own code from ending up where it shouldn't be.

I have an access application that I developed for a customer. While some of the code is unqique to their application, some of it is re-usable which I use in other applications. If I turn the application over to the customer, is there a way to keep my re-usable code out of their hands? thanks

the edit flash button in dreamweaver mx 2004 is not active. I tried recreating the site cache and also removed the swf file and added it again. anyone know why this is happening? thank you.

Got it. here's a star. Thanks.

Here's a thought. It seems that I could remove the where clause from the crosstab alltogether. Then use your code to insert it by locating the "Group By" portion of the sql.

Yes, I get the idea. But one thing though, how does your code know how many characters are in the existing where clause?

I thought about using a qrydef, but this particular query is a rather large crosstab. I thought that I could make a function to send the query to that (the function) would search for the operator to change, change it to whatever I want, then return the edited query for execution. Is this a sound...

I have a query (created in design view) where the criteria field references a control on a form such as [Forms]![frmCreateWorkOrder10]![WorkOrderID]. By default the SQL uses this with the equal operator. I need the same query, however, I need to change the operator. e.g., <, <>, etc. Any ideas...

Yes an array will do the job, but for my app, constants seem to be a better choice. I thought I had seen constants used somewhere else, however, and wanted to see if I could it to work. Also, I knew about looping through controls, etc. That also lead me to look in to the looping constant...

I have a set of string contants const1 = "some string" const2 = "some other string" const3 = "etc" ... Is it possible to read the value of the variable or constant in a loop by appending the loop counter to the end of the constant name? e.g., const&[counter] example for counter = 1 to...

I need to create a checkerboard border. Either by converting a current rectangle stroke to the desired checkerboard pattern, or by creating a custom stroke. Anyone know how to do it? Please let me know if you do, or if you know of an extension that will do the trick, that would be great too...