Recent content by AgDawg

I am not sure I am doing this correctly but I have a combo box called cboactives with specific names to choose from. What I want the form to do is filter on a column where I have combined 3 columns of actives together. So the form will filter if one of those values is any of those three...

Access 2007 I have googled quite a bit. Still not finding any answers. It gives me the error linking a basic table like the one that comes up when you create a new database so I wonder if there are some settings I need to change or an office update maybe?

I simply want to link a table from one database to another but am getting an Error -1002 with the error description: "'|' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long." I have tried just creating a basic table with one...

I am setting a location database for many locations. These are all connected to sharepoint. What I need to do and am doing manually to this point is replacing table names in all my querys. Is there any code that I can change just the sql in all the querys? An example is that my template...

I think I missing a comma or some quotes somewhere for it to work with numeric data. This gives me a data mismatch as well but I think I am close.

The error message that I keep getting says its a data type mismatch.

I have the cascading filters working perfectly for all my different applications. I now have a number thats in a combo box but I know its a different data type. How should I modify my code? The combo box causing issues is cbosupport as its a number data type while the others are text. Private...

Works perfect Thanks!

I want to have a box pull up that asks the user if they are sure you want to add new record. If no then the update is canceled. Here is my code on the before update currently: Private Sub Form_BeforeUpdate(Cancel As Integer) If Len(Me.GenericCode & vbNullString) = 0 Then MsgBox "Enter a...

Thanks for the error trapping code. That was money right there with the message box.

I have some code to send an excel file but I need some kind of way to handle if the user decides to not send the email? Any help? Here is my current code: Private Sub cmdEmailBuyer_Click() DoCmd.SendObject acSendForm, "Computer Cost Add-ON", acFormatXLSX, "CAO", "CAO_CC", , "Computer Cost...

I have searched around but haven't found really what I am looking for. I have a simple form with a list of a field that contains years. One row item can contain multiple years. So I have another form that contains some basic information such as name and year. Currently the year field on the...

I am currently using the macro to email a query. The query name is qryCAO so it puts the file name qryCAO.xlsx in the mail message. I have a need to rename the file to include todays date. So it would pull up the outlook mail message with the excel file attached that is named "Computer Cost...

Yep figured it out. Was the save line.

Its in the on click event for the button. Should I have it close another way?