Search results

I want to have a query that will subtract a Due Date from todays date and tell me how many days are left/passed in either a positive number or negative just like the DateDiff Function. how do i do this?

Can i edit a query to equal a SQL string just like i do for my reports? for my reports i say: DoCmd.OpenReport "Check Filter", acViewDesign, , , acHidden Reports![Check Filter].RecordSource = strRecordSource DoCmd.Close acReport, "Check...

how easy is it to have access create a table and export it to excel, and then have fields on an already made spreadsheet filled in.

Can i create a query that will have a string in the Criteria box, where that string is assigned a value in VB code? for instance: Dim xyz As String xyz = "TV" and I put in the Criteria Box WHERE xyz = "Pizza"

Is there a way to make sure that no duplicate records show up in continuous form?

This is probably something already talked about, but if i have a combo box that has an "Add New Entry" selection in it, and when the user clicks on it, i want to add what they want in to the table that the combo box chooses from. can I have that "Add New Entry" selection open a form with a text...

Before Update with Combo Boxes - Pro help needed i have a form that i want to stamp with a date when it was last updated. if a change to the form is made it will be stamped with today's date. i used the BeforeUpdate event so that you could choose to save the edits or not so if you didn't mean...

So i have a field called [LastUpdate] that i want to have change to the current date to show when the form was last updated. which event do i use to make this happen and should this be a form event or this field event? I tried using the On Data Change even for the form and then just assigning...

So this is probably an easy question but, I want to have a message box that will pop up and tell the user how many days are left until the due date of an issue. I can get the number of days by using MsgBox DateDiff("d", Date, [CriticalDate]), vbCritical but how do i get it to display that...

I have a CONTINUOUS form that shows all my records. I want it to change the back color of a field when it is a certain value. so far i get it to change back color when the very first record in the list is a certain value, but then it will change the back color for every value and not just one...

This may just be a MS XP thing, but when I open my Database it gives a series of 3 prompts to open the database. The first is a security warning for unsafe expressions, do i want to block them or not, the second is telling me that only MS Jet 4.0 service pack can block the unsafe expressions...

I have a Field that has the values High, Med, and Low. I want to have a header in the report sort High, Med, then Low and not alphabetically. Can I do this?

I have a Database that is on a network and allows everyone to be able to use this database and make changes at the same time. When more than one person try to use a button that i created that prints a report, It doesn't work. Why?

How do I get a Query to do a keyword search in a Table? So far I get it to do a search but it has to match a specific Field in it's entirety.

I have written about 23 pages of code to make a series of checkboxes filter my form the way I want it to. How would i Move that code over to the report so that it will display only the filtered records that show up on my form? All I want is to use my form to filter records and then be able to...

I have a form that has a filter that I designed using a series of checkboxes. When I try and get a report to print the filtered information that is displayed currently on the screen, it will not do it. The report will still print all of the records. I tried saying Me.Filter in the where...

I have a form that shows a list of all of my records in my database. I want to be able to click a button called "Report" and have that print a report that has all the records I have filtered on my form. I have a report in the format that i want it in, however, currently it prints every record...

I have a form that shows a list of all of my records in my database. I want to be able to click a button called "Report" and have that print a report that has all the records I have filtered on my form. I have a report in the format that i want it in, however, currently it prints every record...

i have a checkbox that i change the value of in my code by saying checkbox.value = true. the value changes but doesn't update visually until the mouse passes over the box. i have 5 boxes and 3 of them are fine, but two of them act this way. all the code is the same. i tried moving the...

I have several fields that have a drop down list. Say the Field is called "Age" and I have choices in the drop down menu as 1, 2, 3, and 4. How do I create a query that would accept input from the user to show 2 of the 4 or 1 of the 4 or all of the choices using one query that has checkboxes...