Search results

Try this [Forms]![formname]! [listbox].Requery The .Requery will not automatically popup but should capitalize itself once you press enter. Good luck

DSum("Payment","Sales Data","MonthYear =" & [MonthYear] & " And Sends.MonthYear <=" & [MonthYear])Also I know that I have had issues with the items above that are bold not being in square brackets [] Just remember field names in brackets & quotes...tables and queries just quotes. :)

I have made a quick db in Access 2007. There is a module that is not mine but is free to use as long as you keep the copyright information intact. As for the rest of the code on the forms it is pretty cut and dry. I hope that this helps. Extract the zip folder directly to your C:\ drive for...

That is a good question. Listboxes are different...I don't know exactly what you are doing with it, but you could however change the listbox into a subform that looks at your query and then customize your title row however you like.

I did try all three types and although the bounce wasn't as bad it still did it for me :(

Yes you can change the .backcolor of either a textbox or a label in Visual Basic.

Your best bet for image storage is to store your images outside of the Database and then when you want to view the image you would just change the .picture property of an image control. Are you familiar with using Visual Basic?

I don't know if this helps but I do know that when you are using dates in a query you have to have the # symbol on each side of the date.

I am making this a tip but if someone else has a better solution please comment. System Description: OS: Windows 7 Professional 64bit Office 2007 The issue is when you scroll the navigation pane down (or up) the whole menu list, once you stop the scroll, will jump at least 3 spaces in the...

I am not too sure what you mean by minimizing the Navigation Pane, but I have a database attached that illustrates my point...

Scott Oh, Not sure...what exact error are you receiving? When I print the HAVING clause out it comes out like this: HAVING (((qryNat_Chart.DateYr)=Year(Date())) AND ((qryNat_Chart.DateQtr)=Val(Format(Date(),"q"))-1) & strType & ")) The extra " before the last )) is probably not doing any...

Code to turn on and off the Ribbon: 'on DoCmd.ShowToolbar "Ribbon", acToolbarYes 'off DoCmd.ShowToolbar "Ribbon", acToolbarNo Code to open and close the Navigation Pane: 'to hide the navigation pane DoCmd.NavigateTo "acNavigationCategoryObjectType" DoCmd.RunCommand...

Okay here is what I would like to do...I have an unbound form that has a combobox on it. It's recordsource points to a query. What I would like to code is some first, next, previous and last buttons without using "send keys". So in other words when I press "Next" button I would want it to...

Perfect! That is exactly what I was looking for. Thanks so much vbaInet!!

I am sorry maybe I am not explaining myself well enough...an example of what I am talking about follows: Table "Lease" Lease | Mayburry | Jonestown | Table "Wells" Well | Lease Mayburry 1 | Mayburry Mayburry 2 | Mayburry Jonestown 1 | Jonestown Howardsville 6 | Jonestown Now...

I'm sorry I should have said that I am good on cascading combo-boxes... But I can't seem to be able to figure out what I can do with the word DISTINCT??

I am trying to write a query from 2 tables. The first table is called Leases, holds the lease information. The second table is called Wells, holds the well information. The lease is the primary key in the first table and is joined in a one-to-many relationship to the lease in the Wells table...

@Vassago To answer your question...the problem did occur on more than one database but not all databases. I could not lock down a common link between the problem databases. @missinglinq and vbaInet Thank you for the advice and link. I added My Documents where the databases are located to the...

Hello, I am wondering if anyone else has this problem? I have a Windows 7 Professional laptop with Microsoft Office 2007 installed. For some reason when I open a database where there is a start up form set, either in the Current Database settings or an AutoExec macro, I can not use the...

Sorry to post again but I figured out why the dropdown was not displaying "New" but was able to display "New;(NEW)". The combo box is set to two columns ([ID],[User]) with ID hidden. So with only "(NEW)" set it was hidden. Cheers