Search results

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...

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 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...

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...

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...

I have an access 2007 database with 2 linked sharepoint 2010 lists. I update records a few times a week but sometimes I have a lot of records to update at once so I use an update query to update the list. The end users have their own customized database based upon the market they are located...

Ok I have my database the way I like it now I want to add some time saving features. Many places in my database you must select a sales rep from a combo box to view the records. It would be handy to have a combo box that pops up when you open the database and then you select the sales rep from...

I am not sure what I am doing wrong. Just need to filter records to only show whats selected in the sales rep combo box and and the customer combo box. This should be pretty simple. Here is what I have: Private Sub Combo60_AfterUpdate() Me.Filter = "[Customer]='" & Me.Combo60 & "'" And...