Search results

Ok, thanks, Galaxiom I'm over-writing a couple of my tables with tables I have in archive files so as to "roll back the clock" in some areas that I may have some problems in. And I will be doing rigorous testing to see that this has worked as intended. There is one other question I will be...

well it looked like I might have gotten around this issue, but something else has cropped up. No matter what file I open, Access creates a lock file for it. Opening Northwind creates a .laccdb file. This is really looking strange. Any idea why that would happen? Tools/Options?

lucky that all of that happened in a test copy of work file

AccessBlaster, That is another interesting idea. I have the form working now and appears to work normally, but Access is saying "You cannot add or change a record because a related record is required in table 'Salutations'. Might have to do a three finger salute right now.

Oh.... And I also setup a "Salutations" lookup table that I used with the underlying table and query. I'm going through the subform, query, and table removing that work now.

I just did a compact / repair and that had no effect. The other items you mentioned are also very helpful and I am going through those now. Subform is driven by a query that reads a table. I recently altered the table and query in order to set up a check box control on the form. Maybe one...

Access is turning my db into a locked file, but I cant figure out why. The db has never been split; it is not on a network. Also, it looks like one subform is "locked" while other parts of the db are not. My guess is that there is something wrong with the tables and the queries that are...

After bench testing your code for Address1, Address2, City, StateID, and ZIP/Postal Code, it looks like its working perfectly. Just the way I wanted it. THANKS!

Ok. Which does explain why the value on the main form was changed to "nothing". Thanks

stopher, the code you suggested did have the significant effect of solving the Run-time error '2450': Microsoft Access cannot find the referenced form "Carrier Personnel". However, for some reason, the value was not pasted. And actually the value that was in 'Address1' on the main form was...

After reading through many threads here about copying and pasting via code and trying many examples of various strategies to do this, I need to get some advice. My attempts at this are not working. I have mailing address information for "Carriers" and also for personnel of Carriers with a...

thanks, CJ London I appreciate the input

thanks sneuberg for contributing to this thread. I'll check out the code you posted and the db and see how it goes. I am just curious as to why there are can-grow and can-shrink form properties when they don't seem to do anything. Or, do they actually do something? Also, might have a try at...

I am attempting to use several sub-forms to display the record sets returned by a group of queries. This is just for purposes of displaying entered data. Naturally, it would be really nice to make the sub-forms so that they size vertically automatically, tall or short, depending on the number...

Hey everybody, I am trying to make some simple totals queries mostly for purposes of using the 'Groupby' function. Could someone explain to me why the Totals option is disabled under Home/Records? Doesn't seem to matter what I do using query design to get it enabled.

Looks like i may have solved this by going to File, Options, Current Database, Document Window Options, and then selected Overlapping Windows. "Tabbed Documents" is then deselected. I'm just learning this new version and finding my way....... Thanks!

Hi everyone: I just recently upgraded to 2016. In making forms with this version I see that all forms seem to be "docked" to a.....oh I am not too sure what to call it....a "ribbon" I guess and selected individually when open by way of a tab control. This seems to work well when working with...