Search results

How do you have a date field return the previous month data? For example i have a date field and the criteris needs to be all days from the previous month. So if i was running this Jan 31, 2011, i need it to return me all records that have a date between Dec 1, 2010 and Dec 31, 2010. Next...

I am using SQL Server 2005 Management Studio to create a maintenace plan for my database. When I get to the part where you set up the back up of the transaction logs and i select specific databases, it only gives me one of two choices; all users databases or model database. I have tried both...

I am moving a SQL database from SQL server 2000 to SQL server 2005, both on different computers. I am able to detach but when i try to attach the database on the computer that has SQL 2005 i get an error message saying the file is ready only. I copied the files to the folder where the system...

I have an Access database that is shared with other user that have different resolutions and when viewing some forms it does not look right. If you have multiple users with different screen resolutions, what are some ways of dealing with this? I notice with Northwind DB example, when you...

I cant seem to get this to work, i have three fields and a total field in a form that will not total if one of the three have a null value. field1+field2+field3 = field4, all are number data types, all have 0 default values. Problem: if user needs to change or move a value from say field1 to...

I have a report that I would like to have one field merge data into one record per employee when there is multiple values in that field. For example: Field: Employee Name - Jane Doe Field: Degree - Bachelors of Science - Bachelors of Art...

I would like to be able to double-click a value in one form and paste the value into a field of another form. What code would be needed to perform this?

I need to create a short cut menu in 2007 that will have the copy and paste command. I went to Access help and it showed how to create a shortcut menu using a macro but when i attempted to create this macro i could not find copy or paste in the ACTION column. I also looked in the RunCommand...

I have several DLookups in my 2003 version that work fine, but when i upgrade the db to 2007 they do not work. Is the syntex different in 2007? Here is just an example of one of them used in a form. =DLookUp("[Name]","[FMLA_Yearly List]","[FMLA_ID]=[Forms]![FMLA Log]![FMLA_ID]") I search...

I am having a promblem with the DateSerial function and hope someone can help. Here is what i put in the criteria of the Hired Date <=DateSerial(Year(Date()-1),6,1) I need it to return all employees that were hired less then or equal to June 1, 2009 Instead it is including employees hired...

I need to create a query that will show me the list of Employees that were hired before June 1st of the current year. I have a field called Hired Date and tried to put something in the criteria for this field but nothing worked. example 06/01/Year(Date()) How do write it so it always looks for...

I have researched this and still can not get my custom toolbar that was created in 2003 to show up in 2007. I have hidden the ribbon and would like the custom toolbar to show up when viewing reports. Any suggestions?

Is there a way to turn off or hide the "Customize Quick Access Toolbar" down arrow that is beside the Quick Access Toolbar?

Is this feature in SQL Server? I have a table were the ManufacturerID is the name of the company. Because this is the primary key, we are not able to change if there is a spelling error. In Access i can turn on the Cascade Update feature. Not sure if this can be done in SQL Server. Any suggestions?

Is there a way to print a report when there is no data? I have a report that has three subreports and if there is no record in one or more of the reports the report as a whole looks bad, leaving blank spaces. I would like to have the sub reports show the report and leave the data fields blank so...

I have a 2003 Database that tracks Employee data and the Primary Key in the Employee Table is SSN. On occassion i need to correct someones SSN and because it is a Primary Key this can only be done by turning on the Cascade Update feature. However I do not what to leave this turned on. So is it...

Can you use the DLookup function to look up a value in a query w/o putting in a criteria? Or is there another funtion that i should use. Have a report that needs a value from a query but it not the record source of the report.,

I have a form with a command button that when clicked on opens a second form. I need a message box to come up when the second form returns no records. I need the code to be on the command button Here is what i have that does not work Private Sub Command10_Click() On Error GoTo...

I have a macro that opens a form but i would also what the macro to hide a control on the form when opened, i think this is possible but i can't remember how to set the value of a control to not visible using a macro.

I can’t figure out a way to make an update query to do the following: I have 3 tables, Employee, Personnel Actions and Action Details; I have a form to enter the Personnel Action for an employee but need an update query after the data is entered into the Action Details table to update just the...