Search results

Ok. This is the situation: I have a table that lists variable names. I run a query and get back a variable name. In the code I need to get the value of the variable the name of which I get from the table. So I get a variable name as a string and I need to get the value of the variable the name...

hi, sorry I didn't explain it clearly enough. ModelID is a Public variable, lets say it has a value of 5. I have VariableName="ModelID" How could I get the value of 5 just by using VariableName. Thanks for the help. SWK

I have a variable name stored in a string. How could I get the value of the variable? E.g. VariableName="ModelID" - what is the value of ModelID? Thanks for the help. SWK

Do you create a separate permissions table for each table that you want to assign permissions or have a single permission table for all permissions?

Could somebody give me some help on how record level permissions for users are usually handled? I have ideas how to check if a user could or couldn't execute a function in general, but I couldn't figure out how to check if a user could do something with a certain record - like modifying a...

Thanks Pat for the help, if I understand it correctly it is the same thing than what The_Doc_Man suggested. Just a few theoretical thoughts: Instruments and Secondary Scales are truely different, but their norms are just norms. I can see the technical difficulties implementing this, but I see...

Doc_man, I understood now what is it that you are suggesting - what you are suggesting would certainly solve the problem. But as you say it seems a bit too complicated on the data entry side. I am hoping that somehow I could solve this perhaps by - appending a table specific prefix to the...

I have a table storing Instruments and an other storing Secondary scales. These are quite different animals, so they need to sit in different tables, but they both could have multiple Norms attached to them. So I thought I either create a Norm table with identical structure for each of them...

I am building a database and it seems that I will have a large number (cc. 100) of queries - many of them will dependend on each-other several levels deep. What is your practice to keep them organized? I use Access 2000 now and I know I can use the description field - but what exactly is the...

Thank your very much for your help. This is how I think I will solve this - its not my brainchild I found this when searching the web. (Comments welcome). I have ParentTable1 and ParentTable2 and the ChildTable I will create a junction table with the following structure: JunctionTableID -...

Time and again I come across the problem that I need to store identical type of information on multiple tables (the alternative that I am trying to avoid would be to create a child table with identical structure for each of my parent table). What I would like to achieve is 1. To have an...

I finally found the solution. I paste it here hoping it might help someone. The code below sets the 3 parameters of the InstrumDerivedScaleStats3 stored query and set it as the recordsource of a form. Dim cmd As ADODB.Command Dim rst As ADODB.Recordset Dim prm As ADODB.Parameter Set rst = New...

Now I suceeded to append my 3 parameters to the query with the code below. I can execute the query with Set rst = cmd.Execute but how would I open a form that has my query as its recordsource withouth Access asking for the parameters? (I tried a simple DoCmd.OpenForm "FormName" but although...

Hi, For some obscure reason I need to use ADO. As I learned, I can execute a stored querydef with a parameter in ADO like this: cmd.CommandText = "[InstrumentDeleteEmptyQuads]" Set rst = cmd.Execute(, Array(CurrentInstrumentID), adCmdStoredProc) So far, so good... But when I have a SQL...

Thanks for the try Rich, but I am getting the same error message with your method too. Any other thoughts? I can't find the explanation. Thanks. SWK

I met the following strange situation: I have a MakeTable Query, it runs smoothly with DoCmd.RunSQL SQLstring but when I want to do the same thing with dbs.Execute SQLstring it gives a too few parameters expected 1 error. How is this possible? Do I have something wrong in the syntax (can't be in...

hi, this was code - use the code builder exactly as you described. In Access you will need to use code very often if you need to do anything customised. This may be uncomfortable at the beginning but it makes Access very flexible and you will find countless bits of code around (e.g. the VBA...

Many thanks for the help yellow. SWK

I created an import specification and I want other users of the database to be able to use it too. Where are import specifications stored eg. in the database or in the registry? When I distribute the database are they going to be included? Thanks for the help. SWK

I would try to insert a page break at the bottom of the detail section and switch the visibility of this pagebreak on or off according to the condition you need in the On Format event of the detail section with something like this: If [check your control on the report] = True then...