Search results

Ok, the problem is: I have a check box in a datasheet that does not show if the value is true or false - when the SQL (vba) is set as the record source. The DS opens as a sub form, and within a Navigation form. The loading record source is a query. This works fine. When I use a text box to...

No, the last section of code passes the ID and the control name as ONE value - a string. So, the If statement in the form called parses out the ID value and the control name - where to put that value (by using the pipe symbol as a separator). Oh, and the called form is unbound. Sorry - I...

The variable is a string, ID is an integer. DoCmd.OpenForm stDocName, , , stNewRecord could try: DoCmd.OpenForm stDocName, , , "[ID] = " & Me.txtID If you want to pass parameters: DoCmd.OpenForm "frmAddLineItems", acNormal, , , acFormEdit, acDialog, "RequestID_FK|" & RequestID Then, in the...

GBalcom: is the FMS software worth it?

Yep, you want the ListRows set to more than one. Otherwise you can only see the one, and what use is that in your combo box? Also, change the event to after update, otherwise you cannot type more than one character into the box. Example: I cannot find AAAAAA in the list just by typing.

if you need to check for letters in different positions, you can use Left, Mid, Right, etc depending on where these letters might appear. I did a quick test: Private Sub txt2_AfterUpdate() Dim a As String Dim b As String Dim c As String a = Me.txt2.Value b = Left(a, 2)...

Try something like this: If Not IsNull(Me.txtproductname) Then sFilter= sFilter& "([productname] = " & Me.txtproductname) & ") AND " End If Then just copy and edit the code for the remaining controls. Note, that I used the control names for the IF stmt to check and to pass the look up...

Thanks, Steve. I am not really bothered by the time it takes, not until I move beyond these two small applications. But, that was a fairly detailed explanation, and I realized that I already am using both types of binding - and now I know why Intellisense wasn't helping me out with some of the...

Back to mapping it all out: What have you found to be your best practice at laying out the design of your application? As in using Excel, Word, or just on paper? Maybe I lose the big picture when I go home, or because I am doing so many different things at work, but I tend to create more...

Rx: It seems that late binding is needed if you don't know the exact object you will be referencing, or not knowing the objects' versions. According to MS, late binding is much slower. Steve: thanks for the links! The MS page is the most descriptive MS article I have read so far - perhaps I...

Galaxiom: How would you pass multiple parameters to a form's opening events? It seems the Load event cannot accept argument, and I am not sure how I would pass several args through the OpenArgs parameter without creating a complicated bit of code to extract strings/integers from the OpenArgs...

Steve, nice work. I am not familiar with late binding. Apparently this means I do not need the Scripting Reference, but how would this affect any other FSO properties/methods?

Good idea, Ben. Going to try that copying part. As for the front end, the users are used to using Excel for quite some time, and I just want to access some data. Steve, thanks for the helpful troubleshooting tips.

Is there any way to determine if an Excel file is being edited, and not just open? I am creating connections from an Access database - for testing, possibly for importing data. I found that if the file is closed or open, I can still create a connection and read data, but if any cell in any...

@Dave Where do you declare these public variables? If they are in the form's module, won't they be removed when the form closes? Otherwise, wouldn't they just be considered global variables? I am also looking at using some class modules, though I am not quite sure how to go about...

How do you approach mapping your data? How do you approach tracking global/tempvars through the application? I have been attempting to use Excel to track which variables change on events, and conditions, but it's getting a bit messy looking. Thanks, mjd

Well, the reason being...is thus: We are converting from using Excel to Access. The Excel workbook has about 10 spreadsheets worth of past orders - orders we put in for tools, supplies, etc. I can import them into normalized tables after some work with spelling, duplicates, etc. The reason...

So, how would you go about selecting a record from one recordset and adding it to another? RS1 is set within SubForm1 within Form1. RS2 is set within SubForm2 within Form 2. I would like to open Form1, click a button which opens Form2, select a record or two, and add the selected records to...

Well, my understanding of Windows 10 has just increased a little. Apparently, I changed a display setting a week or two ago that seems to have caused this issue. What solved the problem, and leads me to believe this, is that after screwing with the display settings, using my laptop monitor as...

I am experiencing a technical problem of sorts. My screen, in design view, "splits" when I scroll down or right. So I end up with the form object and its controls moving, but about half of the form stays put, only as a visual - non-interactive. Here is a screen shot.