Search results

Has your DB's paths a template in order to access its ? Has your DB's names a template in order to open its in a Do-Loop cycle ? So, the main question for now is: How you plan to open this DBs ?

Can you explain what you are trying to do ?

I use A2007. In this version I can create DBs in 2003 and 2002 versions. So, I think that you can create DBs in any versions older than you have (2013). Except the multivalues fields I have no knowledge about new features. Only the interface is a bit improved between A 2003 and A 2013. BTW: I...

I think that you don't read very carefully my previous post. Before to paste, start to record a macro. Word will give you (I hope) the exact code to use.

First of all it is a very bad practice to expose a table to the users. Second, I think that is OK if that field show the Supplier ID. This ID will be used later, in a form, as Control Source for a combobox.

I think that you have also an error message. What this message say ? An idea: Run your code except the last line (that fail). Switch to Word and start to record a new macro. Press CTRL+V Is the chart pasted ? If YES, stop the macro recording and edit this macro, maybe this will give you new ideas.

Do a try: Remove the # sign from your fields. Is this help ? The "#" sign is used by SQL when deal with dates so... can be an issue here. Also you should not us spaces in names. So, the "Last Report Date" name of field should be replaced with LastReportDate. The "Date" word is a reserved word...

I think that you have "New Page" activated for the section. If this is the case then remove this setting. Now you should have a continuos report. As far as I know it is not possible to say to Access to start a new page after n sections but, as Goh suggested, you can play with Page Setup, fonts...

The keyboard language ??????

TotalAmount * 18 / 100

I've edited my previous post. Sorry (should be <=90 as JDraw said). Yes JDraw. It work as Control Source.

Sorry but I am not enough skilled to help you with this. Note that the size of the DB can be reduced either: 1) by doing a Compact and Repair from Access 2) by ZIPped it 3) by removing records and/or reports, forms, tables, records etc. 4)... by using all the methods :) I'm sure that someone...

IIF(Datediff("d"[Retest Date],Now()) <= 90, 0, Datediff("d"[Retest Date],Now()))

"The last record" is very relative. This notion imply a sort order. (this is only regarding to the terminology). Regarding to your question, my practice is to use the DoubleClick event in order to set the default value. So, for each control where I like to set the default value I have this code...

Take a look here. Maybe you will find an idea: http://www.access-programmers.co.uk/forums/showthread.php?t=250141

Marvin is right. I try to add more info: In order to understand the logic, do a try: Copy your listbox RowSource (CTRL+C) Start to create a query but cancel the Add Tables window and switch to SQL view. Paste what you have copied (CTRL+V) Run the query and look to the "columns" order. Your...

A bit of Google and a lot of solutions: https://www.google.ro/search?q=linear+equations+systems+algorithm&btnG=C%C4%83uta%C5%A3i&hl=ro&biw=&bih=&gbv=1 What I said is that is not an easy task to code this algorithms. It is not impossible while I do this years ago on a Spectrum "computer" (48 Kb...

The same in VBA If Me.ChkName then ' the checkbox is checked ...... Else ' the checkbox is unchecked ..... End IF

If you will be the single user... no problem. But why to not create a DB in Access 2003 (a very good and stable version). This way everyone will be able to work with your DB, not only the users that have 2013 installed.

Sorry, but I don't understand. Maybe if you will show us what you have until now (your DB).....