Search results

Good Afternoon, I was wondering if it was possible to insert a column into the table which is the source of the form im working on, using VBA? The idea is to save the value of a textbox, and use it as defaultvalue of the column. So that the user only has to enter the value once.. Any...

Sorry for the late reply. You are right, when i make it a bound textbox, it saves the value in the table. But only for one sample at a time. Which means if i have 6 samples, i'd have to enter the value 6 times. Isnt there a way to set the defaultvalue of a field(table) to whatever value a...

cheers, ill have a look.

Thanks for the fast reply. The thing is, when i do use a update query with the criteria and such, and i have a total of 6 samples. It will ask for the diameter value 6 times. And when make a query which looks at a value of a textbox on the form, then the form would have to be active at all...

Well i thought it worked like a charm... It populated the fields on the form just fine, but not the table itself. I am starting to think i'd have to re evaluate the design of the table(s).

Good Morning, Ive got a table which stores information for each sample that will be processed in our testlab. One of the fields is "diameter". Even though the diameter isn ot always the same, the same diameter will be used within each project. Example: So in project A it can be 150,7 and...

Thanks. Worked like a charm. ^^

I put it in the afterupdate event of the textbox.

Thanks, But is it possible to copy the value of that textbox, to the table which is the source of the form? Ive tried the following: [Tables]![tablename]![fieldname].Value=me.textboxname.value But unfortunately that doesnt work.

Good Afternoon, I am working on a form (continuous). And right now, the user has to enter the diameter for every sample number. Is it possible to add a textbox to the form, and let the value of that textbox be the value of all the fields in the query/table? So the user only has to enter...

It turns out that using the CurrentUsergroup is not functioning correctly, due to the fact that some users are in more than just one group. So ive decided to filter it by CurrentUser instead. It works like a charm!

Perfect, cheers!

Got it: CurrentUserGroup() I do have one question though, it turns out that not all the menu's are disabled. Heres the VBA function im using: Public Function menuenabled() Dim i As Integer For i = 1 To CommandBars.Count CommandBars(i).Enabled = True Next i End Function Public...

Good Morning, First of all id like to thank you guys for all the help the past couple of days. Back to the question: About a year ago, i decided to make usergroups within Access and setup privileges for each user. Some have access to everything, some have access to just the forms to enter...

Its working now though.. (for some reason)

Hi there, its me again. I used the following code in VBA Select Case [diabrkrn] Case 100 Me.persinstelnr = 1 Case 150 Me.persinstelnr = 2 End Select And it seems to work, BUT, it only works on the first set of data. And not on the rest (continious form). Any ideas?

Cheers m8. Ill have a look.

ya sorry about the long message ;) It is a field in the table, with a lookup function. So its a textbox but acts like a combobox. The controlname is persinnstelnr, and the field name is perinstel. But ya, i have never used a Select Case in VBA, checking ur link as we speak. Cheers!

Well, i just added me.requery. And it seemed to work, but it did not have the result i want. Its a continious form, and it only worked on the first set of data. :( I need to find an other way to do the selection process automatically.

Good Morning, I ve got the following question. Ive got a table, with one field using a lookup function, linked to a table with settings for the press-machine. Untill now the user had to select the setting he/she wanted. It turns out, the setting depends on the diameter of the sample. So...