Search results

Thank you Bastanu, I will have a look at those.

Thank you for your reply, Arnelgp. I didn't notice I've duplicated that row, so thank you for picking it up. The Excel Macro creates a pivottable and from the pivottable I create a new worksheet with a different format. I then copy the new worksheet to a new file which is the file I try to open...

Hi there I have this procedure which selects date and write it to two tables. Lower down I do a xlBook.RefreshAll. The data from these two tables should then be imported into the Excel file. This is followed by a DoEvent and I then run the Excel macro from this procedure. All my code compiled...

Thank you so much, Arnel, this is working perfectly. I wasn't sure about the Select statement.

I'm able to do the CrossTab querry as explained in the allenbrowne link. I do not have the knowledge to take it further in order to format the report in the way I want it displayed and also print it. I would love to know how to do it all in Access. I have two more reports which I have to use a...

That is ReproductionID. This field defines the puppies belonging to a specific litter in my Reproduction table.

Do you or anyone else have an example database with a printable CrossTab report?

I thought it require a recordset because there are multiple records to select. If I export the query, I need a few user inputs where as in vba I can collect all the values with only one user input. I need to have the CROSSTAB in report format and be able to print it. It's way easier to do it in...

Let me explain why I do it this way. I read the data from tblWeights into an excel spreadsheet to create a pivot table. The whole process will be automated with only one input from the user, which is the litter number.

I want to select data from tblMedicalRecords which match a certain critera and write them to a table called tblWeights. Below is an example of what the SQL query would look like. The records from the table tblDogs have to match the value that is in field ReproductionID with the value in...

That is indeed the case. It's working now! Thank you for your help.

Hi guys I get a Data type mismatch in criteria expression error in my Dlookup expression. When I add a Toggle Breakpoint and step over each line all the values are there and correct. The Dlookup picks up the Motherid but not the Litternumber. I just can't see what I'm doing wrong...

Thankyou Cheekybuddha, that solved my problem!

I have a combobox in my form with a list of all my contacts as rowsource. I don't get any error when I select a name from the list. I also have an after update event and does exactly what it's supposed to do. When I delete a name from the combobox and leave it empty I get this error: Syntax...

That worked, thank you so much. I appreciate your help!

Yes it is.

Hi I'm getting a Syntax error in the RunSQL statement. It must be something to do with the date because it works fine when I leave it out. I did a compile with no errors. DoCmd.RunSQL "INSERT INTO tblDogsChecklist (ContactID, DogID, InfoEmail) " & _ " VALUES ContactID, DogID, (date())"

Thank you Bob and Arnel, both of your suggestions are successful. I really appreciate this forum and these guys who are so generous. Thank you, thank you!!

I assume something is wrong with my second Where condition in the Select Statement. It works when I run it with only the first Where condition. Can someone help me with this, please? Private Sub Price_AfterUpdate() On Error GoTo ErrorHandler If Me.CboBuyer > 0 Then Dim CurrentPrice As...