Search results

I have a subform that I want to print (and export to excel) and it keeps asking me to provide parameters that are already provided on the main form. I'm missing something. Here's what happens. Please reference "TheForm". When the main PCLists form is opened the datasheet view area is blank as...

I found this thread looking for a VBA equivalent to the saverecord macro you get when you create a "save" button. I needed to do other things before the record actually got saved. The [B/] Forms' BeforeUpdate [/B] was the perfect place for the logic I needed to add. Thanks.

OK. The votes are in: Macros on Data: 0, Regular SQL as defaults, in queries and in forms: 3. I've done the final load (until the data changes) of the 125,000 row table. The append query had 6 expressions putting Now() in columns, 5 expressions recording the source of the data (a string...

That's good to know. I'll run that utility more often. Access never experienced a hard fault so NO paging was going on. But the cache probably wound up with the garbage and good stuff all mixed together. Cleaner should be faster - at least a little.

I've done many more trials with macros. Mostly they're a bad idea. And the bigger they are, the worse they are. It doesn't really matter too much what the logic is that's making the macro large. Access seems have have trouble just working its way through I'll call it "text" - the characters that...

I appreciate all the time and effort you're putting into my situation. I have attached the manual input form for the prior implementation. It was normalized as you suggest and had a single time stamp applied to each section every time that particular record was changed. Access knew which parts...

CJ_London, I have attached a screen shot of a segment of the macro. This segment deals with addresses and copying Residence Address into Mailing addresses (to make creation of future mailing lists easier). There are lots of SetLocalVar steps just to see what has changed. If a function like...

CJ_London, OK. I'll try for concise and clear and include screenshots of the macro edit window. For the easy questions, I'm using Access 2013 (32 bit - downloaded as part of Office 365), Win 7 Pro SP1 (64 bit), 16GB ram, Intel i-7 3930K. The application is completely desktop based, no lan, no...

I am resistant to generating a bunch of fake data as that is not going to illustrate the problem I'm having with performance. Instead, I've attached the table definition and a screen shot of the "expert" form that is used to create new entries by hand. Each of the fields on the form has...

In reverse order: spikepl - With the field procedure reduced to one SetField Now() 1700 rows were appended in less than a second. The timestamp is the same for all of them. jdraw - Short answer, we integrate 125,000 flatfile rows we get from the county (registered voters) and augment that data...

I'm redesigning a database that had 1 master table and 5 dependent tables - all with one to one linkage. The 6 table structure was to save space by not creating rows in the dependent tables when that sort of data was absent. The queries, while not hard, were complicated in that they all had...

FYI This is also a problem with Access 2010 the solutions still work. I caused the problem by moving the divider between the navigation panel and the form/design/ panel to the left as far as it would go. I lost the "wide" line that I could use to make it wider again. I was in a hurry...

In the simple case I have three tables. The first has 10 rows with fruits as a column as the Primary Key. The second has 5 rows with fruitsLiked as the primary key and foreign key to fruits. The third has 7 rows with fruitsHated with an index with no duplicates allowed on fruitsHated which is...

I've been developing several databases. Some elements that were experimental are now going "live". My development environment is Access 2010 on Windows 7 Pro. The "live" environment is also Access 2010 but running on Windows Vista SP2. In development, I can drag tables, queries, etc. from one...

After trying most of the combinations and permutations of the . and ! parts of the syntax, I still got no where. But I did find a solution. This may be new for Access 2010 and if so, it really helps. With the Main Form text box selected, I went to the Data tab and clicked the ... on the...

Based on earlier suggestions against Split Forms, I've converted to using a Subform. I still can't get data from the subform into the main form. The simplified main form has 3 text boxes and a Requery button (with macro). Two text boxes are used as criteria in a Query. The criteria for the...

I have created a query that takes parameters from a form, wraps the parameters with "LIKE (*"&parameter&"*)" to search for substrings in the underlying table. The command button on the form Opens the Query which then produces the datasheet view in a NEW TAB. I'd like to do the same sort of...

Hi, I've been working with Microsoft Access 2010 for about 4 months. In a prior life, I lived near San Jose, CA and worked on development of IBM's DB2 SQL product for mainframes. I now live in Prescott AZ. We're Arizona's mile high city (actually 5300 ft - but who's counting) so the weather is...