Search results

You're welcome

Typically, you would use a form bound to the table and the user would scroll through the records to find the one they need to update. They can update the data in any of the controls and it will be saved to the underlying table. You can help the user out by adding a search function to the form...

Using the code you suggested earlier, if your users enter this text into a single control: Great whale, you can only match that entire phrase as it appears (so neither record would be returned). If your users were to enter Whale great, neither record would be retuned for the same reason. Now...

You can use the function with a memo field, but you will still be limited to 255 characters if you call the function in a query. Displaying the concatenated memo field information in a form can be done using Visual Basic for Application (VBA) code but it would be beyond what a typical...

Theoretically, yes it is possible but if I what you are saying here: ...does not match this: I think you mean this (fieldA=something AND fieldA=somethingelse) OR (fieldB=something AND fieldB=somethingelse) If you are going to use wildcards (*), you have to use the LIKE operator not =...

The only way to do this with a custom function. Allen Browne has such a function on his website. Here is the link You would create a new module and a public function in that module. You would then copy Allen's code into that function. You will then need to call the function (typically in a...

Is the login form an unbound form? I assume that it is. I assume that since your control name is cboUser, that the user selects their user name from the combo box list of only valid users. I further assume that the bound field of this combo box is the [Login Name]. (It is generally not...

Thanks Michael. I never could find an adequate explanation of why the % worked in my code.

I had an issue a while back where I was using asterisks (*) as wildcards in the WHERE clause of a query I was building in code and could not figure out what was going on. I ended up replacing the * with % and it resolved the problem. I do not know if that would work for an asterisk wildcard...

This thread discusses a very similar question. Just ignore the code part in the first post of the thread. Since 'TMS-2013-002' is essentially a calculated value, it would not be stored in the table; you would, however, store the components that make it up. I assume that you will also want...

You're welcome. Glad to help.

It sounds as though you need to change the join type in the query on which the form is based (a left join). Since the events are on the many side of the relationship, you can have many event records that could be displayed which you cannot do in a single control. The records of the many side...

Do you mean the sum field in the destination does not contain the correct results? OK, I think I see the problem. I did not add in the existing value in the sum field in the Update query. Try this: mySQL= "Update destinationtablename SET sumfield=sumfield+" & mySUM & " WHERE ID=" & me.ID

I typically use something like the following. It would go after the command that opens the second form. forms!secondformname!nameofcontrolonthesecondform=me.controlnameholdingvalueoncurrentform

You are correct on the first part relating to the jobstatus. As to the remainingscheduledvalue field, if it is just a value that is calculated outside of Access by your project managers then, yes it would just be a field in the project table.

Based on what you have provided, there is a one-to-many relationship between the company and its addresses, so we need a couple of related tables to handle that tblCompany -pkCompanyID primary key, autonumber -txtCompanyName other fields tblAddresses -pkAddressID primary key, autonumber...

OK, technically speaking you do not need the loop. The code would go something like this (air code, not tested): dim mySum as long dim mySQL as string 'check the source table to see if it has new weights If DCount("*","Scale1")>0 Then 'get the sum mySum=DSum("weight","Scale1") 'delete the...

When you say you want to copy the results, do you mean that you want a new record for each successive sum amount of the running sum added to another table? For example, lets say that you have the following 3 records in your scale1 table: ID|weight 1|100 2|144 3|122 So the first time through...

You do not need to move records between the tables. In fact, I do not think that you need tblWOH at all. It comes down to how you structure your tables, so I will focus on that. Once we structure the tables properly, you will, most likely have to recreate your forms. In order to structure...

I'm not really sure that your code follows what you described in your post, so let's ignore the code at present and just concentrate on what you want to do. Can you describe in detail what you want to have happen?