Search results

Okay...I get how to use the format function after looking at it, but where in the report would I place that? In the format property for the control? When I try to do that it starts adding quotes all over the place...

I have a report that pulls date from a date field with the current format being short date, or 12/13/11. I would like the report to show the date as mm/yy. Is that possible to do? Thanks! Access 2007

I'm still pretty new to all of this, so it doesn't surprise me that the event wasn't active. Thanks for your help on this. The sample you provided works like a charm!

Hey guys, Attached my test DB.

Hey vbaInet, For testing I simply created a db with a table and a form. The table has two fields: WeekEnding and Report, with WeekEnding being a date field. Then I created a form that has source data from the table. The form has two fields: a text box that is bound to WeekEnding and a text...

Hey vbaInet, For testing I simply created a db with a table and a form. The table has two fields: WeekEnding and Report, with WeekEnding being a date field. Then I created a form that has source data from the table. The form has two fields: a text box that is bound to WeekEnding and a text...

Hey guys, thanks for the help. Mr. B's post is for a query, this is going to a table so the code provided in the link doesn't work. I'll have to fiddle with it. I also tried vbaInet's code in the Change and After Update event, but no dice. It just populated the field with what ever date was...

I apologize if I'm posting this in the wrong location, but I'm not sure where else to post it. I'm building a form that will have a date field on it. I want the date to always be the first day of the week, regardless of what the user selects from the date picker. Example, if the user were to...

Like I stated in my initial post, the front end is on my laptop.

That's what I'm doing.

Hi All, I'm wondering if anyone has run across this or has any idea what is causing it. I'm running a 2007 database that's split into a front end and back end. The back end is out on the network, and the front end is on my laptop. When I go to make any design changes to forms or reports on...

I fixed it, but it was by creating a relationship between the table the main form was based upon and the linked table.

Hi all, I've got a form that at present has two subforms, each located on a seperate tab in a tabbed page control. I need to add a third tab and subform, but when I try to do so using the subform wizard an select use an existing table or query, the table I want to use does not appear as an...

Thanks! Found it

Hello all, I'm trying to open a report in Access 2007 through VBA, but whenever I try to open it in Normal view it just automatically sends it to the default printer. It works fine in preview and I can figure out if this is something new with 2007. Anyone have any idea?

Yes, Owner Extended is another query. I also made a slight change to that query so that it would pull in the ID, and made a change to the combo box so it would pull in the ID also. I then passed that to the report and it now works. Thanks for all of your help. I wouldn't even have known...

Certainly. SELECT [Owner Extended].[Owner Name] FROM [Owner Extended];

Hummm....that may be part of the problem. The combo box is pulling from a Query and not a table. The reason being is that the table has fields for last name and first name, but I want the user to be able to select the full name from the combo box. The query that the combo box pulls from has...

Okay, that fixed the syntax error, but now after I make my selection in the combo box I get a criteria box popping up. If I fill it in with the same name I selected it opens the report without filtering it. If I just click okay on a blank criteria or put something other than what I selected it...

Hummm...now I get a run-time '3075' error: Syntax error (missing operator) in query expression '[Owner Name]=Test User'.