Can someone tell me how to export a query in a comma delimited format to an outlook email.
I would want to do this programmatically using a button.
Is Access capable of this.
I have a report based on a query that includes a filter value from a form text box.
[forms]![frmMain]![frmSubMain]![frmReports]![txtDept]
If I run the report from my PC, I type the value in the text box "txtDept" and click the button to run the report, it displays perfectly.
If I run the...
I have a modal pop up form for creating a new employee. The form requires FName, LName fields and has an auto number field for the unique record. When the record is saved and the form is closed, I want to go to the new record in the main form which is the last record in the dataset. How can I...
I have a report based on a stored procedure from SQL.
In the report I am including a pie chart. The chart key displays what the various colors in the chart represent.
This is what the key displays. I have described the color where in the key it shows a color square.
blue Sum of...
I am using a SQL statement for my record selection and am including a pie chart graph in my report header.
The key in the graph displays the following:
Sum of command.Carpool 25%
Sum of command.Bicycle 30%
Sum of command.Walk 25%
Sum of command.Vanpool 10%
Sum of command.Transit 10%...
I have a table for tracking transportation mode to work for each pay period. There are five modes 1=Transit, 2=carpool, 3=bicycle, 4=walk, 5=vanpool
The pay period database fields are below. A number is entered for each day representing the mode. I would like my report to count the modes for...
On my form there is a "Pay Period" field. I want to look up the current pay period from a sql table "PayrollCalendar"
When the form opens I want to populate the text field "PayPeriod" on the form with the current pay period using the StartDate and EndDate from the table. It can either be...
Hello;
I have a report that prints from a command button.
The report is set like this.
DoCmd.OpenReport "rptZeroHours", acViewPreview
On my PC the report prints at a zoom 100 and I can click to zoom in and out the way it should normally work.
On some of my other users PC's the report opens...
I have a report that goes to print preview by default.
One of my users gets a default zoom size of 25%.
How do I get the report to always display at 100%
I have a group who are using the same application. A report that they use regularly has been set to print preview. At the preview, the users will go into the page setup from File on the top menu. They will generally print a range of pages from the report.
This one user tries to access page...
I have Access 03. I have reinstalled making sure all of the advanced features are selected and I still do not see any of the tables in my db when I use the linked table manager. If I select all and refresh, it processes as though all of the tables are refreshing and gives me a message saying...
Hello;
I have an Access 03 database front end with a SQL2k backend. The backend was previously Access.
The odd thing is that one of the tables will only allow me to delete records that were entered in the database prior to upsizing to SQL. If I enter new records directly to the table, and...
Hello;
I want to use navigation buttons, but I don't want the new record button to be available because I have written my own procedure for adding new records, do I have to create my own custon buttons, and if so can someone direct me to some code to do this.
Hello;
I'm really struggling with this one. I have upsized my Access 03 backend to SQL 2k. My Access 03 front end has a main form with a subform. Records that are in the subform prior to the upsize can be deleted. Any new records that I add to the subform cannot be deleted. I get "The...
Hello;
I have an Access 2003 database used on XP that has a SQL server 2000 backend.
I want to put the front end on a file server, but when I do my users are not able to save edits and sometimes second or third users are locked out by ADMIN (the first person who logs into the front end).
When...
I have a utility form which is a modal popup form opened by a button on my main form. The user can update job titles, job descriptions, etc. by clicking a button on this popup form (these buttons open small popup forms based on individual tables) When a new record is added to one these...
We are planning to upgrade to SPS2003. From documentation it will install SPServices.
Will it seamlessly migrate our existing team services sites?
I cannot find a definative answer on this. Does anyone know where I can find some good documentation on this subject?
Thanks
I am trying to pass these values to a field in the underlying table. This doesn't seem to be working.
How would I write a CASE statement for this
If Forms!frmSrScreen.Age.Value < 75 Then
!VulnA = 0
ElseIf Forms!frmSrScreen.Age.Value > 84 Then...
On my form, I will be requiring a SSN (social security number). I have another text box that will contain the last four characters of the SSN (text field).
How can I automatically populate the four character field from the text in the full SSN.
I have a data entry form with a list of questions. If I scroll with my mouse wheel I go from record to record on the form. I want to disable this action so that the user will stay on the current record. I have set the form cycle to current record or current page, but neither works.
Any...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.