Thanks Duane.
Where I went wrong is that I didn't have an actual table of dates. I created a table of everyday for the next 50 years. I got the query working as I had hoped, but I will test your way as it looks much cleaner.
I have also solved my next step problem.
Hello friends,
I am working on a scheduling database and have run into a snag. I have a form which has both a start date and an end date text box. I also have 7 checkboxs that represent each day of the week. When I check a checkbox, it will write the day of the week in a hidden textbox. I use...
Hello,
I have a phone number field whose type is number. I would like to convert it to text with the brackets and dashes being stored also. I know I have seen similar posts but can't seem to locate them now.
Please advise
Thanks,
Dave
Thanks Kkit. That didn't work but I did get it figured out.
When the form was being opened by the command button, the form was being opened as AcDialog. This was disabling the find command.
Thanks for all of the suggestions.
Sorry about the vagueness....
I have a form that is called from another form. When both of the forms are open, the modal form gives me an error when clicking my find button. It is the same button that the wizard creates on the forms. I have tried switching from modal on to off with no luck. I...
Hello all,
I have a form with a command button on it that is used to search the fields.
*************Code*************
Screen.PreviousControl.SetFocus
DoCmd.RunCommand acCmdFind
******************************
I keep getting an error message. "The command 'find' isn't available now"...
Hello,
I have a button on my Access 2000 shared db that will send a fax using MS Outlook via a fax modem. What I would like to do is have Access verify that a Fax Modem is installed first and give a message if one is not.
Any help would be greatly appreciated.
Dave
Well, I guess I wasn't aiming for a discussion, though I did word it that way. What I want to do is to create a form that a user I assign can use to create new users and set permissions. I do not want this user to be an admin nor do I want the user to be able to select Admin as a group.
I have...
Hello,
I design a Access 2003 on Windows XP. The database is split with a FE/BE. The end user wants to be able to add new users and set permissions himself. I do not want this user to be able to have admin rights and/or have the ability to make anyone an admin.
Has anyone out there been faced...
Sure...
This piece of code is in each of the 10 reports that are run.
It either stamps the appropriate textbox with one of these messages.
-------------------------------------
Private Sub Report_NoData(Cancel As Integer)
Dim CaseManager As String
Dim MessageBox As String
CaseManager =...
Aceman,
This is great. I did handle the problem a slightly different way, although your response will definetly be used for other reports.
On the form that the report is generated from, I added 10 non-visible textboxes. When the reports are run, the report will "stamp' its textbox with a...
Hello AceMan!!!
Here is my OnNoData...
Private Sub Report_NoData(Cancel As Integer)
Dim CaseManager As String
Dim MessageText As String
CaseManager = Forms!frm_menu_reports_cm!cbo_cm.Column(1)
MessageText = "There Were No Results For The " & Me.Caption & "." & vbCrLf & "Case Manager: " &...
Hello,
Here are the specs of my project:
Windows XP
Access 2000
I have a command button that runs about 10 reports from my report generator form. This form has the criteria used to populate the queries that the reports are based on. This button prints the reports directly to the printer...
Lameid,
Thanks for the help. I just found the solution. You need to make a registry setting. Here is the link for everyone else...
http://home.indy.rr.com/russval/faxinginoffice2003.htm#_Toc108796489
David
Hello all,
I am trying to setup a fax function that is run from a command button on a form. The reports gather info from the form and the report is saved to the C drive. This works fine for Snapshot (.snp) files, but is giving me problems when trying to attach a (.jpg) or a (.txt) file. Below...
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.