Search results

Not sure if I can do that. The program is dealing with government data that is sensitive. It contains names and addresses, so you can imagine the loops you have to jump through just to get access. Let me keep working on it and see if I can find the root cause. I am guessing has to have...

Got it. Implemented your idea, now have a very odd problem. When I go onto the form with the locking enabled, the form is locked and the correct background coloir is there (light grey in my case). Problem is none of the fields or sub-reports are visible. If in Access I go into 'Form...

DOH!! Forgot about the form locking the form lock button. Guess back to something like a global variable. Is there such a thing in Access? Just need it floating around while the program is running, then do not care about it. Just looked at your code. Very ingenious! Question is the...

Here is a fun one, that comes out of an end user request: What the user would like is a check box, or something, that will allow them to turn on the ability to edit a form. The normal state of this box would be false (ie Read Only). The reason for this is pretty simple, they are in the...

I like the look of this form/function. Just one quick question, I noticed in your example you have two paragraphs in your memo field that you are editing. I can not figure out how you managed to do that. This is something the user would also like to have available.

your code looks interesting, will have to look at that tomorrow

What I am looking at doing is creating a black box function, that will be passed a memo field, open up a form so the user can edit this field in a pop-up box, then pass back the edits to the calling form. Now the question is, is this even possible? If so how do I assign the run-tune variable...

AH OK.... that makes sense

That was the problem, was set to Single Form, instead of continuous forms. Now I just have one other issue, two fields (both descriptions) have been flagged "Can Grow" but they don't grow. This is even when data is being cut off because of the lack of growth.

I have what was supposed to be a table sub-form in Access 2010. Just a list of short records relating to the parent record. For some reason this has switched to a form type view, ie showing only one record at a time, not the list of records. Question is how did I mess this up? How to I put...

I have a form with several fields and a subform. What I am trying to do is write some VBA code so that when any one of the first three fields is changed: A) VBA code will update a field of one of the open tables, B) Access will re-query the forms data source query, C) Access will refresh...

OK I was afraid of that. Not a problem, I will rework the queries so that I am not doing Queries of Queries. Thanks for all you help everyone!!!

One level deeper and its happening again. I have a query that takes in two other querys. I can edit the data in both of the parent queries, but not the data in this query. I checked for control words, didn't see any. Sort of as to a loss why I keep bumping into this. The SQL is as...

You are correct the 4th field is the recordID (autoinc) which is not needed in the query. I changed the variables names Type and Number to something else and it look like it wants to work now. Thanks for the assistance.

SELECT Control.Muni, Control.Type, Control.Number, [Muni] & [Type] & Format([Number],"000000.000") AS LookUp FROM Control;

I have a query, really simple one, 4 fields from a table, and one calculated field based on the values of the other 4 fields. Problem is, when I browse the query I am unable to change the fields, but if I go into the table itself I can edit no problem. What is causing this, and more...

I agree with you 100%. Right now, just working up a 'Proof of concept'. The end user will have to choose which back-end database they want it on in the end.

What I am trying to do seems simple, but the exact method eludes me. What I need is when (unique for each user/session) an Access accdb is opened, three global variables are created and default values are set. These variables need to be active throughout the users session and keep any user...

There is one line of non-delimited text. There is no way to set up fields to be imported since the structure of any given line could be one of 6 different things. I am not the one who created the export/import text file. It is coming from the government and this is what I am given.

I have a wide variable length text file. The record width is between 150 and 450 characters. To add to the complication the file as multiple record types in each file, in no particular order. What I would like to do is write a piece of VBA code that will suck all the data into an existing...