Search results

Maybe it is just because it is the end of a pretty hectic week but I just can't think how to do this. I have a list of contract counterparties (the one side). On the many side we have contracts. Contracts can have a status of "Current" and "Terminated". A counterparty may, for example, have...

OK. solved it - It needed more quotes. Still can't understand why exactly - the single and double quotes thing is very confusing but it works: rst.FindFirst ("[FSPNumber]='" & vblFSPA & "'") Thanks for the help

I am getting a data type mismatch in a Find First. The line of code is: rst.FindFirst ("[FSPNumber]=" & vblFSPA) I have checked that the field (FSPNumber) is a text field and the variable vblFSPA is declared as a string and the data it stores is from a text field. I am sure I am doing something...

Thank you for the advice. I used Tempvars (not without a lot of headscratching) so that it will skip saving on BeforeUpdate provided it has saved the record already.

Most of my forms have a save button on them. What I find is that when the user click on the save button and the code executes, Access jumps to the BeforeUpdate event which, as a default, has similar code in it. It jumps when it hits the line in the Save button code which commits the changes to...

I am building a filter for a multi parameter query. Users select from the dropdowns and then the code assembles the criteria. I am not seeing the results that I expect. The code is a re-use from other forms where it has worked effectively. Of the three criteria, one assembles properly, one just...

OK, I see. That works if I put it in a different colum. I was trying to convert the DatePart but that was overcomplicating it. Thank you.

I have this: SortByMonth: Format(DatePart("m",[DatePublished]),"mmmm") DatePart gives me a number for the month but I want to show that as a name. The above defaults everything to January so that I get: rather than the words for each of the months. Is there another way to do this?

That worked, thank you. Great to have the help to sort out what I find to be very confusing.

Thank you. The problem is now a data type mismatch. My first variable is a string, the second is an integer. Does that change the syntax?

I have the following code to open a form: DoCmd.OpenForm "frmCStdContractPOPIA", acNormal, , "[CVName] = " & vblType & " AND [VersionNumber] = " & vblVersion The variables work fine but it gives a syntax error. It looks right to me. What am I doing wrong?

Awesome, thanks. Worked like a dream!

I am trying to open a form with multiple criteria. I hae tried various combinations but come up with either syntax errors or type mismatch." DoCmd.OpenForm "frmCStdContractDefaults", , , "[CVName]=" & Me!StandardContract & " And [Version] = '" & Me![Version] & "'" This one gives me a missing...

Thanks. Took a bit of time to figure out but works like a dream. Awesome to get such help so quickly

Hi I have but it is not viable - there is too much information in the query

I have a one to many relationship. One table is Products and the other table is Classifications. Each product has at least one classification but some have two. In a normal query I will link the two tables and get the product information twice and the only difference between the rows will be the...

In the end I with with Find and Find Next and a bunch of if statements rather than try to sort the Seek out. The tables were native and not external and I couldn't see why it didn't work. Current solution is maybe a bit slower but it isn't a big set of records so works fine. Thanks for the help!

Using a recordset because it picks up criteria from different columns in listboxes and I don't know if you can use a variable in a SQL statement. The Seek statement looked fairly straightforward until now

I tried that "Set rstLink = dbsLMD.OpenRecordset("tblCPList", dbOpenTable)" but it gives an error 3219 - Invalid Operation.

I am trying to locate and then delete a record based on two criteria. For this, I understand I need to use Seek. For Seek to work, I need to define an index. When I run the code though I get "Operation not supported by this type of object" when I hit the line that defines the index. The table is...