|
by: KJ |
last post by:
We use a third party software package for acctg that limits us on
field size - as a result, we at times have to enter an item into the
app multiple times in order to get all the information. I then
created an Access DB that is linked to the information and have
combined all data onto one record so that we can export to excel. The
next step for me is to eliminate all the other instances of this
particular item, leaving me with only the...
|
by: Jason A. Thompson |
last post by:
Dear Access Gurus,
I have a database which I hoped to use to administer questionnaires,
or rather that someone who knows nothing about Access could use to
administer them. Each q'aire item is on a different form and I dropped
in command buttons on each to move forward and backward through the
"pages" of the q'aire. Problem is, the first record in the common
underlying table is overwritten each time we go through the q'aire.
(The code to...
|
by: neptune |
last post by:
I must be missing something obvious. I have 3 fields and sample data.
7890 26592 7/15/2003
7890 13645 10/6/1999
7890 58741 6/21/1992
I want to select only the most recent record. It is sorted descending
by in the query and subquery. In the query Total, I
select Group By , First and First
|
by: James |
last post by:
I have a bound combo using a lookup table which is behaving as
expected with the exception of the first record.
In the list of rows for my combo, the first is '.'. This is because of
another issue I had with a bound combo box, whereby nulls were
populated with values (A known bug with MS).
If my first record has a value other than period, when the user first
loads the form it is displayed as a period, & subsequently my dataset
is...
|
by: RayPower |
last post by:
I'm having problem with using DAO recordset to append record into a
table and subsequent code to update other tables in a transaction. The
MDB is Access 2000 with the latest service pack of JET 4. The system is
client/server, multiusers based. The MDBs are using record locking.
Here is part of the code:
Dim wkSpace As Workspace, db As Database
Dim rstTrans As DAO.Recordset
Set wkSpace = DBEngine.Workspaces(0)
|
|
by: byuphil |
last post by:
My subform is displaying records from a table. Using the master-child
links I am able to pass all of the necessary keys to show the correct
information.
When I try to select any item from a displayed record, a textbox or a
combobox, the focus is returned to the first record almost immediately.
If I am really quick and after a few attempts at wild clicking I am
able to select information from a drop down to edit the intended record
or...
|
by: zack |
last post by:
This query has been driving me crazy, and would be grateful for a
nudge in the right direction. Still pretty much a beginner using
Access 2003, I just cannot figure the solution to the following in the
query design grid.
I have 4 tables:
tblApplicant Person
Person ID PK
tblCourses Applied
|
by: John Sheppard |
last post by:
Hello there,
I have a report with a subreport on it. The subreport is meant to show
multiple child record for each master record. But it only shows the first
record.
When I open the subreport by itself it shows all the records, but when on
the main report it will only show the first.
The link master/child fiends are set correctly.
|
by: Henry Stockbridge |
last post by:
Hi,
I have a main form (bio info) with a tab control containing three
pages (employment, financial and dependent, respectively.) When I
move record to record on the main form, the correct information is
displayed on the tabbed subform. However, when I go to, say, the
fourth record on the main form, and click a different page on the tab
control, the main form record reverts back to the first record.
Any help you can lend would be...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|