Search results

there's a sample db forum on this website and microsoft has one too (http://office.microsoft.com/en-us/templates/CT101172481033.aspx).

databases. design, development and deployment. - Rob/Semaan (McGraw Hill)

search these forums and help files for recordsets and BOF (beginning of file) and EOF (end of file). in vba help just type bof and you'll get 'BOF, EOF Properties'.

if you need, there are websites and sample dbs around that supply complete lists of states, countries, etc. you could even copy data from a web page if necessary. also, some people use zip codes as their 'locator'. search these forums for samples and other ideas.

there may not be a next record. check for the end of the recordset first (and the beginning).

true, true.

i'm sure you'll get some great responses but also search the forums for similar threads (and check the bottom of this page for similar threads); there are other posts about this lying around. (i'm going to move this to the small business forum.)

i just remembered it. i don't post in the cooler much but i posted in that thread and remembered and looked it up. :) noone's posted since last september. i just added a post though.

recently finished the latest season of MI5/Spooks. still great and still getting better. also recently finished the latest season (2) of Damages (Glenn Close). really good. start with season 1, there is carry-over to the next season.

more here: http://www.access-programmers.co.uk/forums/showthread.php?t=156603

many to many relationship just meant, instead of this relationship: tblDevelopments to tblContractors (many to many) create this relationship: tblDevelopments to tblContractors_Jobs not sure that makes sense. what i mean is, create this first: tblJobs -> tblContractors_Jobs <-...

- create a query based on the second table; - turn totals/grouping on; - set criteria for color = the color field on your form; don't show; - set criteria for size = the size field on your form; don't show; - set the 'total' row for id = max; show; - do a DLookup of id and add 1.

welcome to awf. could be from the form itself. have you tried setting 'Dividing Lines' to No?

hey 2007. welcome to awf. you should be aware that when you leave a record the record is saved. if you leave one tab to go to another tab, an unsaved record in the first tab will be saved. you have to hide or lock everything on the form to prevent users from leaving each form/tab to control...

start a new thread for this question and include as much info as possible, like what you wish to export, etc.

possibly: i = DCount("SendingDept", "maintable", "SendingDept='AACP' _ and RDateMPU>=#" & Format(Combo1, "mm/dd/yyyy") & "# _ and RDateMPU<=#" & Format(Combo3, "mm/dd/yyyy") & "# _ and reason like 'No Frontsheet Attached*' ") it sounds like one of the parameters entered is the wrong...

hi, i've tried setting the decimal places to 2 and also left it on Auto and both add the decimal places. maybe the control isn't reading the data type correctly (assuming it's currency). try replacing the control, might get lucky. or maybe an input mask is getting in the way?

possibly you need: Between [Forms]![frmRange]![txtStartDate].Text And [Forms]![frmRange]![txtEndDate].Text

if it's a currency data type in the table, you can set the decimal places property to 2.

you should be able to just put this in a textbox's control source: =[lstMyListBox].[Column](2)