Search results

Thanks Pat, I appreciate your time on this, i take it using the Case switch statement would also be okay to use rather than if statements? I suppose both will allow user selection to select which query to append to the forms recordsource. Select Case Me.Frame2 Case 1 Me.RecordSource...

Thanks Pat, i now understand where you are coming from and why Rich questioned why i was doing it that way. Your statement has interested me, can you give me an example using querydef's in this situation? Many thanks Matt

I take it you are reffering to using a form with a query attached to it instead of hard coding it? I basically don't want to use this method, i would prefer having an unbound form that would allow me to use the case statement to select what the user would be searching on. What is wrong with...

I have the following code in a continuous form. What i would like the form to do is loop through and display all of the records on the form. As you can see i have placed a loop in the code thinking that this would then display all of the records in the recordset, but it still only pulls out one...

As kennHigg says follow the Database Life Cycle and you wont go far wrong: I normally follow: 1.Requirements Analysis (Define spec from users and producers of data). 2.Logical design (ER modelling and Normalisation). 3.Physical design 4.Data Distribution 5.Database implementation and...

Just to let you all know placed update queries into app and works fine. 1 gets changed to P on incoming data and P gets changed to 1 on outgoing data. Proberly a bit crude but it works. Thanks for all of your time and inputs on this one. Matt ;)

Hi Rich, I did think about using an update query, i actually put one in place but then thought the following: The data , once gone through this application needs to be exported back out and back into the main business system DB. If i used the Update query to change all 1's to P's i will need...

I may be getting a little confused here then. The control which is called txtProductClass is on the subform. The end user wants to see any class code which this control displays equal to 1 to display a P instead. There are no other objects involved just the one txtProductClass control...

Ah! The form is an actual subform called Final1 Will this make a difference? Do you have to reference the control on the form using the full identifier rather than Me Matt

Nope, still stays at 1 This is getting silly. :o All i have done now is changed the name of the textbox for naming conventions sake, everything else is as before. Private Sub txtProductClass_AfterUpdate() If Me.txtProductClass = 1 Then Me.txtProductClass = "P" End If End Sub i have also...

Sorry dude, Still no good, still stays as 1 Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.ProductClass = 1 Then Me.ProductClass = "P" End If End Sub Matt

Text, field size is 1

Thanks Milo but you would have thought that your suggestion would have worked. Putting in the comas around the "P" as its text, nope, still stays as 1. Matt

Hi all, I take it knowone has any answers or suggestions on this one? Matt

Ok, what am i doing wrong? Thought this would work: Private Sub Form_AfterUpdate() If Me.ProductClass = 1 Then Me.ProductClass = P End If End Sub It just remains at 1 when a 1 value is in the recordset. I thought if a 1 value is present it would just change it to P when the form is updated. Matt

I have come across a problem where i have a fe db accessing a be db using ODBC. I am wanting to distribute the application using the Access 2k runtime. This works ok to a point. As soon as the frontend starts to query the backend, the runtime program stops and closes down due to an application...

OMG!! :eek: I have just found out that Sub Queries are not supported in MySQL 3.1. I am using an ODBC driver to connect to a mySQL db which in turn queries our business system. No wonder it wasn't working!!!

Hi Jon k, The data type for field SUPP_CUST is Text. I take it that would cause a problem ? Does the Max part of the sub query look correct? Matt

Hi all, I need some really quick help here: Can anyone see any problem with the following: SQL = _ "SELECT trans00.SUPP_CUST, trans00.PART, trans00.MFTR, trans00.TRANS_QTY," & _ "trans00.TRANS_DATE, trans00.SELL_PR " & _ "FROM trans00" & _ " where PART = '" & AktProductNo & "' " & _ " AND...

I know i keep on about this but i really need some help. I posted this last week and some of you tried to help but still it doesn't seem to work. I converted most of the Danish to English just to help last week but now i will post the lot as is. I must keep the code as is apart from any...