Search results

Re: Need Help You need to be more specific with your question. Where are the fields you want to relate to one another (all separate tables?) and what is the common factor which links them? Give an example so forum members can better help you.

DoCmd.Minimize - Have a look at this: http://msdn.microsoft.com/en-us/library/ff837032.aspx also DoCmd.Maximise and DoCmd.Restore. Why do you say your form has to stay open to use the parameters? You can store the values in public global variables (in another form or in a module) from the form...

The raw data for SMS_IN is presumably the SMS text as received? You could use CurrentDb.Execute "INSERT INTO tab_01 (sms_txt) VALUES (" & strText & ");" [not sure of the syntax here, as I'm using my iPad now, so can't test]. Next, you can use a loop to insert the values from strArray1 [in the...

You might try DoCmd.MoveSize in your dialog form's Open event.

This is similar to a problem I had. I have adapted my solution to fit your data (as I see it). One problem you face is the likely differences of syntax your users will employ - in your own examples, you use two fifferent variations. I have built the following code behind a command button named...

Good morning. Yes, in form design view, Property Sheet Data tab - it's the 'Record Source' field. You would do this for the called form. Correct. Just add ORDER BY <field name> at the end of the SQL string. If you want to look at query options, you may find this link helpful...

OK, so what you need is something like this: In the Form Record Source, enter a query on your table "SELECT * FROM dbo_ExtendedIncidentDetails;" - you can do this in design mode or at run-time. At run-time, in the Form_Load event code, retrieve the record key as you have done and add a filter...

What is the record source of the form you are opening? The offset is relative to that. Have you tried Me.RecordsetClone to find the record you want when you open the form? What about filtering the form to select the specific record - is that an option? So rather than using DoCmd.GoToRecord, just...

How are the values of fields populated? If they are the result of calculations, then the differences may be due to them. The fields as displayed show the precision of the format, which will round up/down. You could try rounding the numbers before the subtraction, but it really depends on how the...

Something like this may do what you want? Dim intActualScore As Integer, intResultantScore As Integer, intTargetScore As Integer intTargetScore = 20 intActualScore = 22 intResultantScore = intTargetScore + (((intActualScore + (intActualScore Mod 2)) - intTargetScore) / 2) I tried this with...

Where is the definition for strPassedArgument and how do you get the Open Arguments into it? It may be that your're missing an essential part of the interface here? Assuming you have identified the record you want in Form 1, the call to open form 2 might look like this: DoCmd.OpenForm...

For generic control handling, you could use something like this: Dim ctlItem As Control, bytNo As Byte For Each ctlItem In Me.Controls If ctlItem.ControlType = acCheckBox Then Rem following assumes the remainder of the checkbox name is numeric bytNo = Val(right(ctlItem.Name...

My solution to this one is to use the NewRecord flag to determine what is shown in the combo box. When true, the combo data source query has 'where valid' to restrict the selection and when false, no where clause. In essence, filtering according to circumstance. That way records which use the...

Spelling error in CurrentDb.Execute ... ("Exceute") - correct that and it should work

Those issues can be handled programmatically with a little thought. As you say, there's no telling what the user might enter, so you must cater for each likely possibility and have a re-prompt message if it's not possible to decode. Your constraint of not using a form limits the options. You can...

The InputBox function may give what you need.

IIf evaluates both Truepart and Falsepart before returning its result, so the error is in the CLng() where the source field is null. As far as I know, you can't do what you want with the empty field, so you may need a conventional If statement: If not IsNull[Date] then...

if you put your expression within a Format statement, it will return the text you want: Format(iif([Text32-Text31]>0, 5.00),"00000.00") What happened to the false part of the iif statement?

Dates in queries are always #mm/dd/yyyy#, irrespective of your locale. If you change your Format statements around to "mm/dd/yyyy" it should work.

Yes, I know your error is run-time, but I thought the syntax of your split funtion would cause a compile-time error because intNr sat outside of the split. Chris spotted the intended use which I had missed and he's given you the code you need, so hopefully problem solved! :-)