Search results

Not related to your reported issue, but rather than having a separate database for each year just for resetting the autonumber (?), keep all your data in one BackEnd database, and use a sequential numbering scheme as your identifier for the generation of new sequence numbers -- such as YYYY99999...

Paul's answer will do perfectly fine. Not sure what JBB intended, but Paul is right again with the recordset theory. So that you can compare the simplicity of DLookup but be able to use a RecordSet if you need to iterate through a record collection, here is the code. It should be placed after...

Re: button created to copy and paste a field Rather than have duplicate data, when the Name is needed and it is null, then pull the value from field B, but if B is null also, then pull it from field C. Not sure why you would have incomplete data though...

Try: SELECT PatientOT.[PT#], PatientOT.[MR#], ChargesAppliedOT.ReferenceNumber, ChargesAppliedOT.BillingTotal, Format(Now(),"yyyymmdd hhnnss") AS Expr1 FROM PatientOT INNER JOIN ChargesAppliedOT ON PatientOT.TableID = ChargesAppliedOT.TableIDTX WHERE (((ChargesAppliedOT.ReferenceNumber)>1) AND...

1. Is "text result" the output of your query? 2. Can you post your query?

Mike's got the answer for ya right there. If you want to update your entire table, use that field in your SELECT query and convert it to an UPDATE query. But, BACKUP YOUR DATABASE FIRST.

You and me both, and I need to get crackin' on the Ribbon interface. This site will be the first one I will go to when I have the time: Avenius Gunter, site specializing in Access 2007 Ribbons

:) No need to feel stupid at all! Happens to all of us at one time or another.

Okay, so the employer let you take the Job Interview Test home with you?

Can you explain in words what you are trying to accomplish? What values in the variables/controls are you starting with, and what is the desired result?

Support, yes. Sell, no. Big Difference between the two. When a version becomes Legacy (Ac2003- in this case), Microsoft shifts the business plan to Supporting only for a period of time. Supporting is maintaining, not Developing. I've read every word you have said, and we will agree to...

Two responses: 1. Not surprised, as that is only one example. There are always exceptions. With your example, do [u]you[/url] want to continue to support multiple versions, and have to worry about the differences between each? 2. Lack of Return On Investment.

Have a look at these examples which will give you many more options: Sending Email and attachments from Access using Automation (MS Outlook) Sending Email and Multiple Attachments from Access using Automation (MS Outlook)

1. Is the Combobox Bound to a field from the Form's RecordSource? 2. What is the RowSource of your Query? 3. Does it return more than 1 field? 4. What is the Bound Column? 5. Is it by chance a Numeric Value representing a Primary Key for the text values in another table? 6. If so, then you will...

Can you better space out the field header row and the records? Add | between them for clarification. The three examples have no consistency in format, except the last four positions which appear to be an incrementing number but repeats? More information about your format is needed... If you...

One/some/all of these should help you figure out what to do: Dynamic report form a Crosstab Query Dynamic Crosstab Report How to create a dynamic crosstab report in Access 2002

I would guess: Form Name is incorrect, Control Names are incorrect, or the Form is not open when the Macro is run. Are any of these true? Verify each -- if correct, post your SQL Query here.

Inventory Control, Software or DA: Kick-Start Data Models for Database Designs might help you get started. Important thing is to get the tables right first. When you feel the table structures are correct, post back what you have (in text form) along with a description of what you are modeling...

Is your form bound to a table/query, and do you have a Continuous Form? If so, add a TextBox Control to the Footer Section with the Control Source: =Sum([ControlName]), where ControlName is the name of the repeating TextBox Control in the Detail Section to add up. Otherwise, please describe...

One can guess, but how about provide some details what the meaning of the two fields are about and what explicitly makes 5/d the unique choice?