Search results

Does anyone have a simple vba code that allows me to import all the content in a specific folder into an Access attachments field? I have search but all I am seeing is code to import outlook attachments. :banghead:

I have a main form with several linked by ID worksheet sub-forms. I would like to add a on-click function to delete the main form and all related record on each sub-form. I have tried several methods but nothing is working correctly. The cascading delete function is not available as part of the...

I am using a simple form to set filter options to a query. One of my fields is a Multi Selection list box which users can select 1 or more options. The selected items in the multiple selection list box is stored in a comma-delimited string programmatically called “Selections” which, is included...

I have a form with a field called "comRpt" listing all the reports available to run on AfterUpdate procedure. I would like to add a commend button when clicked the selected report shown in the "comRPT" field runs then it is attached to an emailed. Does anyone have any ideas how I can accomplish...

I have created a simple flash form which contains links to several databases shared by multiple users. Each database has its own login screen to restrict user access and permissions. It is possible to create one login screen in the flash form which validates if the user has access to a database...

CJ_London, I also just solved it by using MonthNo: Month(DateValue([Month] & " 1")). Thank you for your recommendation.

CJ_London, The PYMonth and CYMonth fields are formatted as Format$([Usage Ending Date],"mmmm"). When create a report I am unable to sort the months based on a date. Is there a way I can add the month number to each or as a seperate field?

That worked!!! Thank you,

Hi CJ Landon, Your recommendation to create two separate queries to capture kWh totals from current to previous year than a third query to joined them together by location worked great. But, now I would like to show the kWh detail by month for each location. Any recommendation on how I can...

CJ London, The sample database includes the actual tables and queries. I have also attached a sample of the report which I am currently populating manually and I would like to automate the process using the data.

CJ_London, I have another question. I need to show our energy consumption comparing results current to previous year by month. I have tried a few different approaches such; as adding a month field to both pervious and current year queries but, I either get the correct data from current or...

I have a query joined together by two tables based on a [LocationCode] field. The first table “Locations” contains each location detail including [LocationCode] and [strGrossSqFt]. The query results shows the fields [LocationCode] and [strGrossSqFt] repeated thought-out the table wherever the...

Sorry meant to say "Fire" and not Hired... I was able to get the code to work. When I enter a duplicate date the message box appears just the way I want. But now have another problem. We have 35 employees using this same form to report their time for the same dates; if another employee enters...

Still allowing me to enter duplicate dates. It appears the code does even hire.

I have a main form which employees use to report their bi-weekly time. The main form is automatically assigned a [RecordID] and the employee must select their [Profile] from a combo box. This main form contains (2) sub-forms. Both sub-forms use the same data source table. The first...

I am using the follow code but, nothing happens when I enter a duplicate date If DCount("*", "tblEmployeeTimeReportDetails", "[Reporting Date] = " & Me.Reporting_Date) > 0 Then MsgBox "The date you have enter already exists. Please check date and try again.", vbOKOnly + vbExclamation, "Date...

I have a main form which employees use to report their bi-weekly time. The main form is automatically assigned a [RecordID] and the employee must select their [Profile] from a combo box. This main form contains (2) sub-forms. Both sub-forms use the same data source table. The first sub-form is...

I have a query table in Access 2007 with requests pending an individual’s review and approval. I would like to create an automatic email each day to that individual which includes the actual query table impeded as part of the body of the email (not as an attachment). Any ideas? Thank you in...

I knew that... It has been one of those nights. Thank you again.

Beansy, Thank you for your post. When I run the code I get a "Compile Error: Syntax error" message on the line If Err.Number = <error number> Then