Search results

Surely you and your company got better things to do :rolleyes: RV

Add a column to your query. For field, enter KyFld(yourcolumname) Replace yourcolumname by the actual name of the memofield column in your table. RV

Try assuming Restock and ItemID are numeic strings. RV

Using TOP is not really a good idea. Stick with the Max function instead. You need to include your user column in your query if you want to retrieve rows per user. PS Eigenaar should read Owner, User stands for Gebruiker :D RV

Look up the function Max in Access Help. Don't use reserved words such as Date, Field, User. They will cause mayhem. RV

Well, that next time you need to put on you glasses first before jumping to conclusions :D Rv

Have a look at these links / sites http://www.codeproject.com/useritems/CurrencyToWord.asp?df=100&forumid=33566&exp=0&select=744298 http://www.tek-tips.com/faqs.cfm?fid=1764 RV

Using quotes like "this is extremely, EXTREMELY urgent" "help me please - this is totally urgent" will not help you to get any helpfull replies. Take into account that this forum exists by the grace of volunteers. RV

For the query that comes with Form2 you mean? You'll definitely need VBA to build your criteria and pass the selected values to the query. Rv

Syntaxis for control sources is a bit different: =DLookUp("Hours","Shifts","Date = Date") To distinguish between object names, put txt in front of your form field. Don't use Date as object name, it's a reserved word and will cause mayhem ;) RV

You forgot to add an alias in your statement for the subquery: UPDATE sales AS S1 SET S1.EXPC = (select count(*) from sales AS S2 where S2.order_id = S1.order_id AND S2.product_code = "EXPC"); RV

Base your subform on a query. Sort on the appropiate column in your query. RV

Similar questions have been asked before... Use the serach facility of the forum, you'll find, for example, this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=112507 RV

Indeed, forgot to mention that in my previous reply. Code was removed from all reports as per the sample. Reports and queries where replaced by one report plus one query. Added a new form that enables you to generate a report per month, per year and for all years. Rv

Your query refers to two fields on your form. Now if you export your query, it can't find those fields as, apparently, you don't run the export from within your form. Hence the error message. Run the export from your form. RV

Here's a brand new version, enjoy. PS had to remove the picture in your form in order to upload the file RV

Here's another one, to be put in the After Update event of your field: Me.fieldname= StrConv(Me.fieldname, vbUpperCase) RV

Open the form, that comes with the button that results in the error when clicked, in design mode. Right click anywhere in the form and select Properties. Now, select the button. Navigate to the tab page called "Event" In the On Click event, it will show [Event Procedure] Click in the field, an...

Shouldn't that read that SQL Server requires to use unique identifiers on tables? Rv

Have a look at the TransferText Method in Access Help. Also, search the forum as similar questions have been asked 'bout a zillion times. RV