Search results

Try this. Open VB editor (ALT+F11) then CTRL+F search for Northwind Traders. Select search Current Project and hit find next. Change the title. HTH

Try this: me.[Due Date] = Date me.requery Or change the name of the Due Date control to DueDate then use me.DueDate = Date me.requery NoSpaces in the control name.

I am trying to modify the Microsoft Contact Management Database template. On the Contact list form there is a hyperlink to Show/Hide Columns. The event is an embedded macro RunMenuCommand Command UnhideColumns. I cannot figure out how the popup form is linked to the table or how to modify the...

Try this: On the click event on the report in vb put Docmd.Close 'put the code from the button that works here' That should close the report and then run the query with the prompt and open the report again,

:banghead: OF COURSE ! I guess I was overthinking it !!!!! :eek::banghead:

I am not sure of a way in vb(there maybe though). I would try and draw a rectangle around each field in the report. Might be a work around. Good Luck

I am very new to charts/graphs in Access. I was able to create the chart data using a query and was able to create the chart in a report (it is correct). However the charts repeats itself 12 times. I am sure it is because the query returns 12 lines of data. It is a chart of Sales by month (12)...

I have a main form with textboxes and a "search" button to filter the data and display the results in a subform. I am using code to set the record source from the values in the main form. Right now it is just using "AND". Example Vendor like "*ABC*" AND Date between datestart and dateend. This...

Thanks Bob and Sean - I got it to work using code from Bob's website http://www.btabdevelopment.com/ts/exportformrecordset Worked like a charm. Damn you're smart!

Bob, I am using your BuildFilter to create the recordset for the subform. It has the Like & AND built in. How do I use that filter to create the query?

Good question Sean. Actually I really only want to export it to excel to send to a customer. However, I read where access will truncate memo fields > 255 char. so the get around (the way I think) is to append to a temp table and the export the table. I read where exporting the table will not...

I have a form where I have fields that can be filled in to create a filter. Then the results are returned in a subform. Works Great! Now I need to Append the "filtered" records to a table. I am not sure how to create a query using the filter. I set the recordsource of the subform using the...

I want to EDIT the record if it exists but AddNew if it doesn't. With your suggestion I get too few parameters expected.

I am using the following code to Add a new record to a table. This works fine. However how do I modify the code to find an existing record with the ProposalID and Edit it instead of Adding a New. Do I need some sort of If statement before the AddNew or change the OpenRecordset ???? Not sure how...

Perfect. Thanks

I have a control I need to roundup to the nearest year. Here is the control source i am using =DateDiff("y",[txtIssueDate],[txtIncomeStartDate])/365.242199 It returns 4.89538176283 using 5/9/2009 as [txtIssueDate] and 4/1/2014 as [txtIncomeStartDate] How can I get it to return 5 ?

Have you thought about using a hyperlink field to the actual document? That way you can easily access the document from the record.

I have a DB with an attachment field. The DB has quickly grown to 2 gig because of the attachments. I need to export all the attachments to a folder and the change the design to a hyperlink rather than an attachment. The table tblWO has 2100 records that have attachments. Is it possible to...

Thanks Alan and Michael. I found a work around for my situation. I'll study the code from Michael at more length.

This didn't work. Not sure where to put Nz.