Search results

Sounds good! I will check it out. Thanks!

Okay I guess no one else seems to have had this issue, I am going to share my experience on how I solved this: 1. Since I had 2 different installs of Office on my Computer I thought that was a good place to start. 2. Removed the Microsoft Office 2013 installation. 3. Removed the Microsoft Visio...

Hello, I hope someone else may have encountered this. I am trying to install a chart on a form in Access and am receiving this error: Chart Wizard Automation error Library not registered I am using Office 2016 Professional with Visio 2013 installed on a Windows 10 Enterprise 64-bit OS. Can...

Sorry my mistake. I meant 2 different queries and should have stated that. Thanks for the help.

Thanks for the link. Are you sure this won't work? SELECT * FROM dbo_AFETaskView WHERE (((dbo_AFETaskView.StatName)="In Progress") AND ((dbo_AFETaskView.Created)<=DateAdd("d",-3,Date()))); Because I am receiving the desired result.

I am working on determining records that are under or over 3 days old. I just can't seem to get the syntax for Access correct. Here is my SQL query for greater than 3 days: SELECT * FROM AFETaskView WHERE Created < DATEADD(day, -3, getdate())I just can't seem to work it out for Access...

Hmm interesting...I have had projects work for a while and then stop working...is there anyway you can zip up the DB without data and attach. I will take a look at it if you would like.

If you want to open the form to a New record you would open it with the Data Mode set to "Add"

I am sorry I miss spoke in my post " "Like '*'" removes records with nulls from the query." Here is an example of what I am trying to explain. Say you have a table with 3 columns City State Zip and it is populated like the following City | State | Zip | Chicago | IL |...

Try creating a subform and then placing it on your form with your combobox then set your Link Master Fields to your combobox and your Link Child Fields to the controlling customers field of your subform. Once you choose a customer with your combobox it should display its record in the subform.

Hi Bart, Looking are your Tables...it seems to me that you have 2 main tables and 3 tables that hold multiple items. Here is how I would set up this Database. tblEmployee EmployeeID (PK) LastName FirstName EmployeeNo Crew RecDate tblPhone EmployeeID Phone PhoneDate PhoneID (PK) tblRadio...

I don't know if this would help...but I would change Form property to Allow Edits= Yes and then lock down the fields that you want locked from the property page.

Hi Mike, You would change it in the WHERE Clause to reflect the Primary Key that the Form (Demo) is using to display the current record. But I wouldn't change this Query, I would make a copy of this Query and change the copy until you get the results that you want. That way you always have...

I have had issues in the WHERE Clause that if I don't encase the key's name in brackets [] it may not work. So I always encase DoCmd.OpenForm "ClientServicesInput", , , "[Clientid]=" & iContactID

Hi phinix, Sorry I am not too sure about Windows 8 but the only fix for the Navigation Pane jump that I have found in Windows 7 is on the "Make it easier to read what's on your screen" is to keep it set to "Smaller = 100% (default)"

If every field of your search criteria is set to "Like '*'" then every field will have to be populated with something. "Like '*'" removes nulls from the query.

Yes there is always another way: I have created a function that places my calculation into textboxes. So I have done it with VBA + the calculations will change if there is more than one pump and I change to a different one.

I am sorry but I am not sure what you are trying to do... Please break it down step by step maybe I can understand better of what you are wanting to accomplish. Thanks

Try building a query from the criteria on your form and then run it. Then with the query running go to the create tab >other forms dropdown and choose datasheet. That will create a new datasheet form > save it, close it and then drop it onto your form as a subform.

Not too sure what you are trying to do... but I always find that if you can't do something to go back to when you could get the form to save. Then try to make your delete button again.