Search results

Hello all, I know what is causing my issue but don't know how to fix it. I'm sure someone can point me in the right direction.... I have a button on a form that outputs a report to pdf, saves in a specified folder, then attaches it to an email. It's worked perfectly until I had the need modify...

I've got a weird thing happening; hopefully can get some advice here. I am working on a new form. Designed it as continuous form, which I will later develop with some filters, buttons. For now the datasheet serves the purpose. I have set these properties of the form: Default View: Datasheet...

Hi all, I have the following VBA code working correctly, except for the wierd placement of the attached pdf in the body of the email. Here is the pertinent code. 'Build email variables strTo = Me.txtSContactEmail Debug.Print "Email to " & strTo strTo = Left(strTo, InStr(strTo, "#mailto") - 1)...

I have a table with a field called air_week. I can calculate a text value of it's 'Period' using the datepart function (y and q), and formatted as YYYY-Qx (where x is the quarter number). I have used that Period data in several places throughout the database. What I'm looking for in a query is...

Hello all, I've got a spreadsheet organized roughly like this. Many more rows and 13 sets of columns(plus two total columns) for 2021-Q1 Weeks. I need a formula for counting dates (they are in text format) across the rows at Date Count, and by row where dates are entered with comma separators...

Hello all! Long time no post. Hope you are safe and well. I have a hyperlink field for the email address in my contacts table. On my Insertion Order form, the email address is used for a command button procedure to 1) save the Insertion Order to pdf and 2) attach that PDF to a new Outlook email...

Hello, all. Hope this fall day finds you well. Simple problem, I think. I want the On Current Event of a subform to trigger hiding/showing field columns on datasheet of a second subform. If subform1 field called Plot = "Weekly" Then These fields/columns on subform2 should be visible: AirWeek...

Hi. Hope everyone is well. I'm not sure this is possible so I'm here to find out. I have a combo box on a form with LimitToList property set to Yes. The data for the list is from a lookup table. Sometimes the user will select an item from the list but then may need to add a little more info...

Hello all, This is probably easy, but I cannot figure it out. I have this function in the module of a subform. The subform filters the data for a specific DetailID on the main form. All works correctly except that it is returning 's' for all dates in the underlying table, not filtering for...

Hi all, I am attaching a small db file to get some help with a new approach I am trying to take with my project. Currently, I have the user doing input to a similar dialog with a subform of dates (some of you have been a big help on that form). Anyway, he's finding that a little cumbersome, so...

Hello all, I need to revisit a previous thread that mostly resolved my problem. I have this popup form with subform that user enters dates into. I have entered a series of dates in the subform. The Dates box on the main form is calculated ... =DatesToTextBox(), code as follows: Public...

Hello, all. Is there a function out there for changing a field entry to proper case in the after update event, that traps and corrects problems like this: Washington DC becomes Washington Dc McGurley becomes Mcgurley 1125 NW becomes 1124 Nw etc. Thanks in advance! MIB1019

Hello All! In my database, the objects open is TAB view, rather than separate windows. I want all of the forms to retain the default context menubars for the controls, (so that I can use cut/copy/paste, sort, etc.) I want to disable the context menus on the tabs themselves. User will have the...

I have my application using tabbed documents rather than separate windows for forms, etc. I need to modify the context menu on the tabs and don't know how that is addressed in VBA. I believe the Shortcut Menu property for the form relates to the records, not the tab itself. Will be creating...

Hello, I have a subform called Journal Subform, with a combo box called cboContact_ID. The same subform is used on two different main forms. The two main forms hold company information, including a Company_ID. I have VBA filling the combo box on the subform with the SQL statements, varied only...

Hello, hope you can help me. I have moved a database (front-end and back-end) to another computer, ready for the user. The Linked Table Manager is having an issue with one table, fails to link to it. I get an error that I need to check the table name for puctuation and name length. It has...

Hi, I have a button on a Dashboard form to close Access. May have several objects open in the database, so want to close the program 'gently'. Current Database properties include Compact On Close. What would you suggest? Thanks! MIB1019

I have a popup form for a user to populate a simple subform with dates. Here is a picture of the subform... My goal is to gather the list of dates into that textbox, called txtDatesSelected, in mm/dd format, comma separated. There could be up to 20 dates in the list. The subform control is...

Thanks again, in advance, for your help. I'll have another couple of questions on this after this little issue gets resolved. I have a button on a form that opens a popup form to get a list of dates. There are four values to be passed to the popup. Here is the code for button click event...

I've got a query that contains a field Air_Dates, and a calculated field to find the Week Start Date of the Air_Date (week begins on Monday). The query field/calculation is: Week: DateAdd("d",-Weekday([Air_Date],2)+1,[Air_Date]). The query won't sort on that field, gives a data type mismatch...