Search results

i wonder if you have a backup database from last year? If you do, then you can compare two tables if there are any change. If not, then i don't know.

I think the Mid function from SOS should be like this: Or the Mid Function - Just set the update to be for the ones with two letters at the beginning: Mid([YourFieldName],3,len([YourfieldName]-2)) for the ones with three letters at the beginning: Mid([YourFieldName],4,len([YourfieldName]-3) )

I have a table to compare current sales unit price and forecast sales unit price for some sales inventory by model number. See below for an example. Model current future variance B-type $10 $20 $10 C-type $20 $18 -$ 2 D-type $30...

Open design view of the original table (Not report) then add a validation rule on that field.

I don't think you need to join two table into one table since it seems like you have all data you needed for analysis. I think the way you created for the Select Query is not quite what you needed when I looked at your problem that you said "the Access grouped each value". If you go back to...

If the user has access to both buttons, then why not just create ONE button with a message if the user really wants to make the change? If the answer is yes, then allow the user to make change. If the answer is no, then direct the user away from the field.

I forgot to mention this: the last field (in my example is FIELD 15) should have the order number.

You may want to create a query to find out where the "200" is in that field by MID function. I would create a number of fields based on the lenght of that order field minus 7 plus 1 . E.g. If the order field is 21 characters long, then create a query with 15 fields (21-7 +1=15): Field1: iff...

It's in a Macro. The To is an option built in the Objectsend.

I have a simple SendObject comand to send a table to an email address. It works except the email "To" section has the same email address duplicated and one blank line in between. The focus is shifted to the 1st letter of the blank line. I tried the "CC" and "BCC" and the same problem happens...

The link is quite helpful to locate old 2003 controls/commands in 2007. However, Microsoft didn't put the similar info for the Access 2007's macro tab. Probably I need to go thru all the action commands to determine what they are. Anyway, thanks for the link!

I recently converted my old databases of Access XP to Access 2007. In the Macro tab, there are new action commands in Access 2007. I wonder if there is a cheat sheet to tell what a similar action command would be in Access 2007 compared to an old Access XP's action command (e.g. 2007's...

Yes, it is AFTER i download the query's result in an Excel. That's ok if there is no such format function in Access. Thanks!

I have concatenated the rounded value from a currency field with the value from a text field to a new field (e.g. 4.56 CHF or 1,789 EUR). I wonder if there is a special format function which allows aggregate calculation after I download the output to a spreadsheet. Eg. Row 1- 1.01 CHF Row...

If the original 2 columns are already set at Number format, then you should not use double quotes in your formula. You should use the formula like this: Newcolumn3 = [oldcolumn1] - [oldcolumn2]

Terrific! It worked. Thanks!. I'll keep that in mind not to use the term "Join" in that way.

I converted my old database of Access XP to Access 2007 recently. I updated the transferspreadsheet action like below: Transfer type: Export Spreadsheet type: Excel Workbook Table Name: XXXX File Name: C:\ABC\Export.xlsx Has field name: Yes However, it seems like the export function works...

Those two columns are already in the same table. The original download data of the number column has inifinte decimal places (e.g. 567.89893483 or 7.1 or 123787.009). What I wanted to accompoish here was to show only two decimal places for number and its corresponding currency into the new...

awsome! It worked. Thanks.

i'm new to Access 2007. Whenever I right click a table or query and select rename function in the submenu, then it looks like the focus would only be stayed in that table/query just a couple seconds then somehow be shifted to another table/query so I didn't have enough time to type the new...