Recent content by mbaue002

I am trying to concatenate two cells, one of which has a superscripted number in front as part of a footnote. Is there anyway to keep a superscripted number in a concatenated cell? I already tried hardcoding the number into the formula and editing it, but that does not work.

okay so heres what I did.. Private Sub CmdRun_Click() Dim db As DAO.Database Set db = CurrentDb() Dim rs1 As DAO.Recordset Dim strInstrument As String Dim sglCoupon As Single Dim DteSettlement As Date Dim strSQL As String Dim qdf As DAO.QueryDef sglCoupon = Me.LstCoupon...

Thanks I will give this a try.

how could I put this into code? I thought setting a docmd to run the above sql statement would open the records, but that didnt work.

I basically have 3 pull down menus that I am using as a filter in a sql statement to sort by the 3 criteria. I can get a record count, but basically am looking for a way to create some sort of form out of the records meeting the criteria. So I basically want to turn results from an sql statement...

I have set a string equal to sql to match records to pull down menus. This works fine and I am able to get a record count, but I want to run this and have the records meeting these criteria open in a form. I figured I could use a Docmd. to achieve this, but am not having any luck. Any...

Thanks for all the help guys, I got it working finally.

I have tried this, I get a run-time error 424

The data it will be returning for now is just a simple record count. I tried to merge them at the WHERE clause but got a 424 run time error. I figured I could do it either way, but couldnt get the syntax right to merge them at the WHERE clause.

I am very new to VBA. I am trying to add the two statements below together and get a record count when the two criteria are met. I tried to use an if and statement, but had no luck. Does anyone have any suggestions on how to put these two statements together. Dim db As DAO.Database Set db =...