Search results

I'm using access 2003, with the + sign i can collapse my subdatasheets. I'm using the form/table view (all records shown at the screen). When opening the form in the on open event I placed RunCommand acCmdSubdatasheetExpandAll This works fine and collapses all the subdatasheets in my form at...

Oops think i found it. Executed this in sql server query analyzer, this code could be entered in a stored procedure and the proc can be executed in access. SET CONCAT_NULL_YIELDS_NULL OFF select lijnnummer, send_key,convert(varchar(4),lijnnummer)+convert(varchar(4),send_key) As expr1 from...

I have a table and would like to merge all the fields into one text field of the table after the insert. I'm using adp (access/sql server). When using standard sql the null values give a problem and i don't want to use the if clause as it will give too much coding. Example fld 1 fld2...

platform : access (adp) / sql server Problem : form filter not executing in subforms When I goto one of my subforms I can activate the form filter. When executing the form filter no records show up, it just keeps showing my criteria. When disactivating the form filter I receive an error...

access 2.0? I don't know :-(

This shows rural's way when passing data of different data types . You can use conversion functions. Private Sub Knop12_Click() On Error GoTo Err_Knop12_Click Dim intFld3 As String Dim stDocName As String Dim stLinkCriteria As String stDocName = "Vw_Test2" intFld3 = CStr(Me.Sender_Id) + ";"...

Ok rural thanks it's working!!

sorry rural i was posting when you were posting, will check it out!

Ok think i found a way: Make a public function for instance: Public Function PassValue(A) PassValue = Forms![Vw_Sender]![Sender_Id] End Function This function will store the number of sender_id (a control) of the form vw_sender. It will take the number for the open record. In your...

Yes, pass values but can i use these values to fill a new record??

yes in access 2003 right click a control and use conditional formatting. You can make expressions referring to other fields. If you want to skip set the default record disabled (in the conditional formatting it's the little box) or set your conditions to disable the field. When using your tab...

I'm afraid openargs is only being used to find records, not to add a value in a new record

I have one dialog form which can receive values from multiple forms. For each form i can build a popup dialog version but that's to much time in administration later on. The best thing is if i Can declare a variable from the source form and pass it to the target control box in the dialog form...

There might be an easier way: In the report editor use insert>microsoft office pivot table 11 Then you'll be having a real matrix!! All you need to do next is apply formatting to have the matrix look good at the report. I've been using it in an adp file (access project) on a sql server...

ooppss.. maybe i can import all my objects and code into a new database without data. I will try whether it works

Because of a data-import I would like to import all new data into existing tables. Therefore I first need to dump all my existing test data throughout 30 tables which have several relations. Is there a command in access or a batch script which performs a bulk delete among all tables?

Thanks guys i will give it a try

When a order (identified by orderid) of products reaches a certain status I lock the article numbers (with an orderrule number 1 to many to that order-id) from changing. This works ok, the user can't change the article numbers and quantities. What doesn't work is the fact that they can still...

I have a form with several tabbed sub forms. My main form has a relationship ID (company) which is also used in the subform, they are linked and it works ok. The subform maintains the orders of the relation. When a user chooses another company in the main form I automatically would like to...

Yep I got it working like this: If Me.FIELDNAME1 = [FILL IN YOUR CRITERIA] Then Me.FIELDNAME2.Locked = True Else Me.FIELDNAME2.Locked = False End If (In this example fieldname 1 is different than fieldname 2) Remark: you can't reference a field in a form higher than the current one (I didn't...