Search results

http://p2p.wrox.com/access/32446-make-linked-table-vba.html Amend for FoxPro Dim dbsTemp As Database Dim strMenu As String Dim strInput As String ' Open a Microsoft Jet database to which you will link ' a table. Set dbsTemp = CurrentDb ' Call the ConnectOutput...

Query error - The number of columns in the two selected tables or queries of ... Why do you select certain fields and then * to bring theme all in? Where is the UNION part? I'd wrap Date in [ ] also as it's a reserved word.

The AutoNumber in the existing Table will increase on every append. Have you imported/deleted any test data? Does it start at a high number but increase in order?

Why not just use the Format Function to display it the way you need for each db? http://office.microsoft.com/en-gb/access-help/format-function-HA001228839.aspx

Tip on opening a Report for a specific record using a Query. http://www.599cd.com/tips/access/open-report-specific-data/

You can just create an unbound Form, just call it Main Menu, set it as your startup Form in Options. Then you can add buttons, using the wizard, that will open other Forms you've created.

Cross Post http://www.accessforums.net/forms/dsum-function-39929.html

So there will be a "-" separating them?

What is the code in your textbox?

What is the name of your Table/Query? DSum ( expression, domain, [criteria] ) DSum("Price", "TABLE/QUERY", "Article = Baby Milk") http://msdn.microsoft.com/en-us/library/office/ff193998.aspx Video, basic DSUM. http://www.599cd.com/tips/access/130809-dsum/?key=AlexForum

Will it have the "-" separating the Countryname and Personsname or was that just to indicate the separation? If it does you could use Find, Search, InStr or Split to get the two parts.

Will the XXX always be of a certain length or could it change? Would it be camel cased? SSSPhilipinesXxxx

You could add them in another row as an OR criteria.

The second link should do that. You just need to create a Query that selects the single record you want. Base the Report on that Query then Print.

There is a Search box at the bottom of the Form which you can use. Or you could create your own. http://www.599cd.com/tips/access/multi-field-search-form-like/?key=AlexForum You could create a Report based on your current record and print that...

DateAdd ( interval, number, date ) "number" can take positive and negative numbers so just type in "-1" to your textbox. (Or whichever number you require) Add a button "cmdClear" Depending on the names of your textboxes that you are using to input your Days, Weeks, Years to add/subtract...

Have you tried the Toggle Filter in the Ribbon?

Say you have an unbound textbox on your form, let's call it "txtCalc". You could then add a button to your Form. Rename it "cmdAddRemoveYear". Now in the events tab click the ... Button next to the Click event. Open the Code Builder. Sub cmdAddRemoveYear_Click() End Sub Now you can say...

Looks like you're doing a great job. I'm sure you can pass in negative numbers into the Function. You have the right concept so if you want it to add other parts just amend your code to look at other textboxes and there equivalents: DateAdd("yyyy",[YearsCalc],[Date])...

http://www.accessforums.net/forms/creating-command-button-form-containing-drop-down-39742.html