Dear NeoPa:
I'm afraid I have little knowledge on networks or whatsoever. Nevertheless, I agree with you that this problem with the autonumeric field is something like weird and should not be expected. But even more strange to me is the loss of data; I think that this last one may be a network "crash" and wrong recover of information (recovering a past copy of the access file and not the previously current one). In fact,...
limperger
Last Activity: Oct 23 '08, 06:22 AM
Joined: Mar 31 '08
Location:
-
Loss of data in an Access file placed in a network
Hello!
This is quite important. We have an Access file shared in a network. Every user has its front-end copy that is linked to a back-end copy.
This database has an autonumber field to count the records. Surprisingly, one day we found out that the autonumber count had elapsed 500 records; that is, the last entered record was assigned number 650 and the new one was assigned number 1100 by the autonumber field. I didn't... -
Dear NeoPa:
Thank you for your response (as always).
Best regardsLeave a comment:
-
Hello!
Could someone have a look on this?
Best regards!Leave a comment:
-
Maybe if I paste here the SQL statement, it will help:
[PHP]SELECT [CALCULO IPI].[IPI CALCULAT]
FROM [CALCULO IPI]
WHERE ((([CALCULO IPI].HISTORIA)=[Forms]![Registro_frm]![HISTORIA])))[/PHP]
"Calculo IPI" is a query that makes a calculation which is displayed in the "IPI calculat" field. With the specified criteria, it only makes the calculation for the selected record in the "Registro_f rm"...Leave a comment:
-
Hello Stewart:
First and foremost, thank you for your response.
Let me explain myself: when I enter this forum, I feel very humble. My Access ' knowledge is similar to that which may be learnt using an "Access Bible" book, with no knowledge of VBA or SQL. In this forum, topics beyond my Access ' knowledge are dealt and I have the impression that I have posted topics that are far easier to deal with than the...Leave a comment:
-
Unbound fields and queries
Dear all:
I would like your opinion on this: is VBA code used for linking unbound fields with queries (the so called recordsets???). In other words, is there a way to insert data in a form from a data source different than the form's own data source, without using list or combo boxes?
I'd like your answer only, not how should it be done. That is, for example, "yes, there is a way to insert that data in a form without... -
Thank you very much Megalog. I will proceed as suggested.Leave a comment:
-
Hello everyone!
Here's my explanation:
First, just to set things straight: I have got an Access file with a main table ("tbl" from now on), and a main form ("frm" from now on) linked to the table (with a listbox that helps to skip from one record to another). There is a memo field intended to store a final comment regarding the whole entry.
The idea here is to search tbl looking for...Leave a comment:
-
Hey!
Somehow I made it and this time I have been wise enough to keep some notes on how should it be done. Let me post it later. No VBA needed!!Leave a comment:
-
Memo/Text/Hyperlink... field storing a shortcut to an office file
Hello everyone! I do not know if it is possible to do something like this in Access but let me try to ask: Is there any way to insert in an Access field a shortcut to an office file, being all the files (both the Access database and the other office files) placed in the same network??
I envision a form in which, for a particular record, some information is shown. Nevertheless, for additional info, the user must open some other Office file,... -
Dear NeoPa:
This is exactly the situation, word by word. Simply put, most people want to learn how to populate a parameter query via a listbox (and they are redirected to the excellent and very useful Martin Green's Access tips website); I would need the other way round: how to populate a listbox (in a form) with a parameter query.
I have very little idea of VBA, though I plan to learn more about it in the near future....Leave a comment:
-
Parameter query as a List box data source
Hello everyone!
Just in case anyone has any wonder about this... I have a parameter query that searchs for records that have the particular word provided by the user in a memo field (using the criteria Like "*" & [Enter the particular word] & "*"). I want those results displayed in a form. Additionally, a list box is mandatory, to skip from one record to another one.
Unfortunately, when using the... -
Parameter query that launches twice
Hello everyone:
First and foremost: I find this case below difficult to explain so let me hereby present my apologies if someone's willing to help but does not understand what is all this thing about...Just let me know and I will try to explain it better.
I've got a form with a list box. The list box type is that in which the data for the record selected automatically appears in the form. The records (ctrl source) come from... -
Thank you very much for your help!
Best regards!!Leave a comment:
-
Book "Access VBA 2007 Programming for Dummies"
Hello everyone!
I'd like to know your opinion about the book Access VBA 2007 Programming for Dummies, as a way to learn Access VBA fundamentals. Could anyone here recommend any other book on this topic, in an introductory level?
Best regards -
For anyone who understands spanish, I've found the following link very useful (about VBA):
VBA fundamentals
Best regardsLeave a comment:
-
Dear Linq:
Thank you very much for your help! I am pretty sure these websites will prove useful!
Best regardsLeave a comment:
-
Hello everyone!
If someone else provides other websites, it will be much appreciated.
Thank you very much in advance!!
Best regards.Leave a comment:
-
Useful Access Websites
Hello everyone!
I've been recommended in this forum an excellent Access website full of tips ( [HTML]http://www.fontstuff.c om/access/[/HTML]). I strongly recommend it too.
By the way, I was wondering whether other people could recommend other useful Access websites. May this thread serve this purpose. So let me encourage you to post in here useful websites you know!
Best regards!
No activity results to display
Leave a comment: