I am working on a database application which exists out of a back-end and front-end part. The data in the back-end database will thus be edited by different users. Now I want to add following feature:
When someone wants to edit certain data, but someone else is already editing this data. I want...
The first field of a table that is imported is a number with field size double. But the field size has to be a long integer. All the numbers in this field look like ##.0000000.
How is this done in VBA?
Greatings,
Hans
I'm wondering if it is possible to design a generic query. So I have one query that can be used on several tables with the same properties but with different names. The query has to ask for the tablename on which it has to be performed.
Best Regards,
Hans
Herman,
Thanks for your help. I have tryed it and it worked. But the file I want to import consists of up to 12,000 lines and only up to 300 lines contain the code '117'. Therefore I am looking for a way to import the data more efficient since the data has to be imported every time the file is...
Dear experts,
I'm trying to import data from a file Epl_asc.exf. This file is generated by another programm and is ascii compatible. Within this file I am looking for lines that start with code '117' (at the end of this message I added a fragment of such a file). As you can see the data is not...
Dear experts,
I'm trying to import data from a file Epl_asc.exf. This file is generated by another programm and is ascii compatible. Within this file I am looking for lines that start with code '117' (at the end of this message I added a fragment if the file). As you can see the data is not...
When you come up with something better please let us (read: me) know. I have a comparable problem with a file that has the extention .exf.
Ofcourse I let you know when I come up with a solution myself.
Greatings,
Hans
"there is never time to do it right but there is always to do it...
Okay, that i thought of as one of the possible solutions. But how do i import the text file into the database. I can't figger it out using help. Most of the tutorials i use are in english but the version of access i use is german and i am dutch. Very confusing all together.
Greatings,
Hans
As a not-so-experienced Access user I ran into an interesting problem. Namely, I want to search for data in a txt-file, which is generated by another tool. This txt-file contains 25 columns each separated by a comma. When the second column contains a value that satisfies a certain condition the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.