Search results

Great - I will try that right away! I always thought you were suppose to load data events with On load so that you don't reload them all the time as you do with On Current. But I'll go with whatever works :-) Thanks for your help equilib

Good point - but as I have set triple state to no in the properties I don't think it will do the trick. It neither explains why it works in afterupdate and not in onload. Best, Equilib

Yes I run 2007 and updated the settings in the Trust centre but that did not change anything. Here is a mini version of the base. Structure: It takes data in table "Basedata" that are selected on a few criterias and either appends the table "Cartelldata" or updates the ID in that table if...

Thanks for fast reply - but running that onload does not change anything in my form. Capacity remains enbled both when Quotas is checked and not checked...

Hi, I have a strange problem. I'm importing data into a base and when I open a form I want to grey-out some checkboxes if other checkboxes are not ticked in the imported data. I use the onload event and type a simple code: Private Sub Form_Load() If Me.Quotas = No Then Me.Capacity.Enabled =...

Aha - thanks - then it is a single form.

Yes - table1 data stays there - only grows. Yes - form2's recordscource is table2 What do you mean by if form2 is a single or continous form? I suppose it's single - I created it based on the entries in table2 but I'm not sure what a continous form is.

Thanks a lot for your reply. The data to table1 is entered by a form by another team. A lot of the data is already there but they are adding more. Thus - they will work on the same database and there will thus be no dumping of data in table1. When my team opens form2 or table2 the additional...

Thanks a lot. No I understand that nothing is automatic. I was looking for a way to execute a "selection" query "after update" of the form related to table1 and then run a append query upon launch of table2.

It's for scientific research. I have a large raw data set (table1) that I want to keep clean and not do any changes to. This raw data will continue to grow. I want to select and export the observations that are of interest to me to a new table (table2). Then I want to add observations to this...

You are totaly right Ross - it is a one way flow - but I can't get it to work. I have a two forms one for each table (new info to be added in table2). Can you be a little bit more explicit about what you mean by "hook into the open event of the form"? Thanks

Sorry, I may be a bit out or my leauge here. Bob: what do you mean by using the select query as a record source for a form? What does that mean and how do I execute it? George: What do you mean by bound form? What I'm trying to do is to move data from table1 to table2 given a few...

Actually three different queries (in different forms): select, append and update.

Sorry for a very simple question - but I spent far too many hours playing around with it now (both with macros and vb) and I could really do with some help. How do I run a query from a form, example from after update. What is the vb code I should use? Thanks, Petter

Thanks a lot - I'll dig into the code right away

I want to have the raw data in a unique table as it is external data without any manipulation. I would like to separate it in a clear manner from the observations that I pull out - for which additional information will be inserted. However, the selection queary should look the same in both...

Great! - Thanks a lot. No - I want to keep the data in table1 - it is the raw dataset which should not be altered, but will continously grow with more obs.

Because I have a lot of data that I will not work with. Thus I want a clean start with only the observations I'm interested in - it helps for visibility and to get an overview of the material.

Hi, I'm relatively new at this so I appreciate all help. Question 1 I have a table (table1) full of data. I want to export part of this data into a new table (table2). The conditions for the data to be exported is that A or B are true and that C or D are true (simple checkboxes). I tried to...