I am running Access 2002 and just ran the built in Access wizard for
splitting a database into a back end (with tables) and front end (with
queries, forms, modules, etc.).
After running the wizard, I opened the table relationship view and noticed
that all the relationships are missing. Is this supposed to happen? If so,
why? I've noticed that queries are behaving strangely now, seemingly
because the relationships are not established.
Am I supposed to go into the back end database and reestablish the
relationships? Or, am I supposed to do that in the front end database.
This behavior seems odd. Is this an Access 2002 bug?
Thank you for your help!
Ed 20 2977
"Ed" <an*******@discussions.com> wrote: I am running Access 2002 and just ran the built in Access wizard for splitting a database into a back end (with tables) and front end (with queries, forms, modules, etc.).
After running the wizard, I opened the table relationship view and noticed that all the relationships are missing. Is this supposed to happen? If so, why?
It shouldn't but then I've never used the splitting wizard. I'd go into the BE and
see if the relationship view is still there. You may need to click on the Show All
button on the tool bar.
If the layout is missing then use the appropriate sysrels tool from www.trigeminal.com to copy the relationships window layout.
And if the relationships are not indeed in the backend you can still use the sysrels
utility to copy the relationships window layout. You'll have to drag and drop the
relationships yourself but that'll be less work.
I've noticed that queries are behaving strangely now, seemingly because the relationships are not established.
Tell us more.
Am I supposed to go into the back end database and reestablish the relationships? Or, am I supposed to do that in the front end database.
No, relationships are always created in the MDB in which the tables reside.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Tony Toews wrote: "Ed" <an*******@discussions.com> wrote:
I am running Access 2002 and just ran the built in Access wizard for splitting a database into a back end (with tables) and front end (with queries, forms, modules, etc.).
After running the wizard, I opened the table relationship view and noticed that all the relationships are missing. Is this supposed to happen? If so, why?
It shouldn't but then I've never used the splitting wizard. I'd go into the BE and see if the relationship view is still there. You may need to click on the Show All button on the tool bar.
If the layout is missing then use the appropriate sysrels tool from www.trigeminal.com to copy the relationships window layout.
And if the relationships are not indeed in the backend you can still use the sysrels utility to copy the relationships window layout. You'll have to drag and drop the relationships yourself but that'll be less work.
Tony, in one app I did I set my relationships in I visited the relationships window
later on and the window had myriads of tables in it, lines crisscrossing all over the
place. It looked like a spaghetti western. Is that normal as you define an application
and build and expand it?
Salad <oi*@vinegar.com> wrote: Tony, in one app I did I set my relationships in I visited the relationships window later on and the window had myriads of tables in it, lines crisscrossing all over the place. It looked like a spaghetti western. Is that normal as you define an application and build and expand it?
No. Or rather some of mine do indeed look like spaghetti but then I
designed the layouts that way. <smile> One of mine prints on a 48"
plotter and takes three feet of paper.
I have had that happen when I import the BE into a new BE. The
tables are placed on a grid and the lines are running all over the
place.
But this is where the sysrels utility comes in. It will copy the old
relationships window layout.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Just as an add-in to this thread there is a utility on my site that
allows you to save/restore multiple views of the Relationship window. http://www.lebans.com/saverelationshipview.htm
NEW - Jan 21/2004 A2KSave-RestoreRelationshipWindow.zip is an MDB
containing functions to Save and Restore the Relationships View Window.
Allows an unlimited number of different Relationship Window Views to be
saved.
Here is the Access97 version:A97Save-RestoreRelationshipWindow.zip
--
HTH
Stephen Lebans http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Tony Toews" <tt****@telusplanet.net> wrote in message
news:c4********************************@4ax.com... Salad <oi*@vinegar.com> wrote:
Tony, in one app I did I set my relationships in I visited the
relationships windowlater on and the window had myriads of tables in it, lines
crisscrossing all over theplace. It looked like a spaghetti western. Is that normal as you
define an applicationand build and expand it?
No. Or rather some of mine do indeed look like spaghetti but then I designed the layouts that way. <smile> One of mine prints on a 48" plotter and takes three feet of paper.
I have had that happen when I import the BE into a new BE. The tables are placed on a grid and the lines are running all over the place.
But this is where the sysrels utility comes in. It will copy the old relationships window layout.
Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
"Stephen Lebans" <Fo****************************************@linval id.com>
wrote in message news:AA*********************@ursa-nb00s0.nbnet.nb.ca... Just as an add-in to this thread there is a utility on my site that allows you to save/restore multiple views of the Relationship window. http://www.lebans.com/saverelationshipview.htm NEW - Jan 21/2004 A2KSave-RestoreRelationshipWindow.zip is an MDB containing functions to Save and Restore the Relationships View Window. Allows an unlimited number of different Relationship Window Views to be saved.
Here is the Access97 version:A97Save-RestoreRelationshipWindow.zip
Very clever! Though you could have saved a bunch of time using the built in
Access methods for storing different views by using the SysRel utility I
wrote. :-)
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies
This posting is provided "AS IS" with
no warranties, and confers no rights.
On Mon, 26 Jan 2004 15:42:47 -0800, "Michael \(michka\) Kaplan [MS]"
<mi*****@online.microsoft.com> wrote: "Stephen Lebans" <Fo****************************************@linval id.com> wrote in message news:AA*********************@ursa-nb00s0.nbnet.nb.ca... Just as an add-in to this thread there is a utility on my site that allows you to save/restore multiple views of the Relationship window. http://www.lebans.com/saverelationshipview.htm NEW - Jan 21/2004 A2KSave-RestoreRelationshipWindow.zip is an MDB containing functions to Save and Restore the Relationships View Window. Allows an unlimited number of different Relationship Window Views to be saved.
Here is the Access97 version:A97Save-RestoreRelationshipWindow.zip
Very clever! Though you could have saved a bunch of time using the built in Access methods for storing different views by using the SysRel utility I wrote. :-)
Perhaps, I'm not understanding correctly, but I thought the SysRel utility
saved an internal Blob that represents the relationships. Is there any way to
know it's safe to restore those after changes have been made to the tables and
relationships since the time the Blob was saved? That had been my concern.
I actually wanted to go that route Michael but you have not published
the Source code!<grin>
The code only took an hour or so and I enjoyed the mental exercise.
:-)
--
Stephen Lebans http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Michael (michka) Kaplan [MS]" <mi*****@online.microsoft.com> wrote in
message news:40********@news.microsoft.com... "Stephen Lebans"
<Fo****************************************@linval id.com> wrote in message
news:AA*********************@ursa-nb00s0.nbnet.nb.ca... Just as an add-in to this thread there is a utility on my site that allows you to save/restore multiple views of the Relationship
window. http://www.lebans.com/saverelationshipview.htm NEW - Jan 21/2004 A2KSave-RestoreRelationshipWindow.zip is an MDB containing functions to Save and Restore the Relationships View
Window. Allows an unlimited number of different Relationship Window Views to
be saved.
Here is the Access97 version:A97Save-RestoreRelationshipWindow.zip
Very clever! Though you could have saved a bunch of time using the
built in Access methods for storing different views by using the SysRel utility
I wrote. :-)
-- MichKa [MS] NLS Collation/Locale/Keyboard Development Globalization Infrastructure and Font Technologies
This posting is provided "AS IS" with no warranties, and confers no rights.
Michael I finally took a look at the BLOB data in the MSysObjects table.
I was able to decipher the indvidual window coordinates from the data.
Without voiding any NDA you are under can you tell me if the location of
the window coordinates are fixed/static across all versions of Access?
Or do I need to continue to decipher the header for this BLOB?
For anyone interested the relevant BLOB is in the MSysObjects table. The
desired row has a NAME field = "ADMIN".
--
HTH
Stephen Lebans http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Stephen Lebans"
<Fo****************************************@linval id.com> wrote in
message news:2U*********************@ursa-nb00s0.nbnet.nb.ca... I actually wanted to go that route Michael but you have not published the Source code!<grin> The code only took an hour or so and I enjoyed the mental exercise. :-) --
Stephen Lebans http://www.lebans.com Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit.
"Michael (michka) Kaplan [MS]" <mi*****@online.microsoft.com> wrote in message news:40********@news.microsoft.com... "Stephen Lebans" <Fo****************************************@linval id.com> wrote in message news:AA*********************@ursa-nb00s0.nbnet.nb.ca... Just as an add-in to this thread there is a utility on my site
that allows you to save/restore multiple views of the Relationship window. http://www.lebans.com/saverelationshipview.htm NEW - Jan 21/2004 A2KSave-RestoreRelationshipWindow.zip is an
MDB containing functions to Save and Restore the Relationships View Window. Allows an unlimited number of different Relationship Window Views
to be saved.
Here is the Access97 version:A97Save-RestoreRelationshipWindow.zip
Very clever! Though you could have saved a bunch of time using the
built in Access methods for storing different views by using the SysRel
utility I wrote. :-)
-- MichKa [MS] NLS Collation/Locale/Keyboard Development Globalization Infrastructure and Font Technologies
This posting is provided "AS IS" with no warranties, and confers no rights.
"Steve Jorgensen" <no****@nospam.nospam> wrote... Perhaps, I'm not understanding correctly, but I thought the SysRel utility saved an internal Blob that represents the relationships. Is there any
way to know it's safe to restore those after changes have been made to the tables
and relationships since the time the Blob was saved? That had been my
concern.
It is perfectly safe, and this is what happens any time you modify schema
outside of Access (using ADO or DAO, etc.) and then later open the window in
Access -- it properly discards items that are no longer present.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies
This posting is provided "AS IS" with
no warranties, and confers no rights.
"Stephen Lebans" <Fo****************************************@linval id.com>
wrote... I actually wanted to go that route Michael but you have not published the Source code!<grin>
Ah, I am not allowed to do that. The decipher code was easy enough, but the
writing to the system table is not something I am allowed to release as
source (though in the past I have licensed DLL versions for easy calling
from other tools <grin>),
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies
This posting is provided "AS IS" with
no warranties, and confers no rights.
"Stephen Lebans" <Fo****************************************@linval id.com>
wrote... Michael I finally took a look at the BLOB data in the MSysObjects table. I was able to decipher the indvidual window coordinates from the data. Without voiding any NDA you are under can you tell me if the location of the window coordinates are fixed/static across all versions of Access? Or do I need to continue to decipher the header for this BLOB?
Well, its no NDA violation since I dod not know if they ever plan to change
this. Of course, if they do then they have a wizard to update (the Print
Relationships wizard), so they may well keep it stable.
For anyone interested the relevant BLOB is in the MSysObjects table. The desired row has a NAME field = "ADMIN".
Actually, it is whatever user name is the person looking at the
relationships window (thats why SysRel lets you save it under any name at
all).
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies
This posting is provided "AS IS" with
no warranties, and confers no rights.
Thanks for the info Michael.
:-)
--
HTH
Stephen Lebans http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Michael (michka) Kaplan [MS]" <mi*****@online.microsoft.com> wrote in
message news:40********@news.microsoft.com... "Stephen Lebans"
<Fo****************************************@linval id.com> wrote...
Michael I finally took a look at the BLOB data in the MSysObjects
table. I was able to decipher the indvidual window coordinates from the
data. Without voiding any NDA you are under can you tell me if the
location of the window coordinates are fixed/static across all versions of
Access? Or do I need to continue to decipher the header for this BLOB? Well, its no NDA violation since I dod not know if they ever plan to
change this. Of course, if they do then they have a wizard to update (the
Print Relationships wizard), so they may well keep it stable.
For anyone interested the relevant BLOB is in the MSysObjects table.
The desired row has a NAME field = "ADMIN". Actually, it is whatever user name is the person looking at the relationships window (thats why SysRel lets you save it under any name
at all).
-- MichKa [MS] NLS Collation/Locale/Keyboard Development Globalization Infrastructure and Font Technologies
This posting is provided "AS IS" with no warranties, and confers no rights.
Well since I am not able to write to the system tables I will have to
keep my current method and use DoCmd to Save the current RelationShip
View to the system table.
Thanks Michael.
:-)
--
HTH
Stephen Lebans http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Michael (michka) Kaplan [MS]" <mi*****@online.microsoft.com> wrote in
message news:40******@news.microsoft.com... "Stephen Lebans"
<Fo****************************************@linval id.com> wrote...
I actually wanted to go that route Michael but you have not
published the Source code!<grin> Ah, I am not allowed to do that. The decipher code was easy enough,
but the writing to the system table is not something I am allowed to release
as source (though in the past I have licensed DLL versions for easy
calling from other tools <grin>),
-- MichKa [MS] NLS Collation/Locale/Keyboard Development Globalization Infrastructure and Font Technologies
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael \(michka\) Kaplan [MS]" <mi*****@online.microsoft.com> wrote: For anyone interested the relevant BLOB is in the MSysObjects table. The desired row has a NAME field = "ADMIN".
Actually, it is whatever user name is the person looking at the relationships window (thats why SysRel lets you save it under any name at all).
Ah, yes, I recall a tip from someone, somewhere who stated that if you wanted a
different relationships view to logon to Access using a different userid.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
"Stephen Lebans" <Fo****************************************@linval id.com> wrote: Well since I am not able to write to the system tables I will have to keep my current method and use DoCmd to Save the current RelationShip View to the system table.
Well, yeah, but there's got to be some way of updating the system tables. After all
Michael can do it inside VB in his sysrels utility.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Or you can use my utility to save different views....
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies
This posting is provided "AS IS" with
no warranties, and confers no rights.
"Tony Toews" <tt****@telusplanet.net> wrote in message
news:o9********************************@4ax.com... "Michael \(michka\) Kaplan [MS]" <mi*****@online.microsoft.com> wrote:
For anyone interested the relevant BLOB is in the MSysObjects table.
The desired row has a NAME field = "ADMIN". Actually, it is whatever user name is the person looking at the relationships window (thats why SysRel lets you save it under any name at all).
Ah, yes, I recall a tip from someone, somewhere who stated that if you
wanted a different relationships view to logon to Access using a different userid.
Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
"Tony Toews" <tt****@telusplanet.net> wrote: Well, yeah, but there's got to be some way of updating the system tables.
After all Michael can do it inside VB in his sysrels utility.
Yes, if you call Jet directly then there are all kinds of ways around rules.
In this case, the table in question is not secured using Jet security, so it
is easy enough to write data (for tables that have actual Jet security
permissions-based restrictions, this method would not be helpful).
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies
This posting is provided "AS IS" with
no warranties, and confers no rights.
"Stephen Lebans" <Fo****************************************@linval id.com>
wrote... Well since I am not able to write to the system tables I will have to keep my current method and use DoCmd to Save the current RelationShip View to the system table.
Well, one could always call this other tool. Not everything has to be done
in the database to be considered helpful. :-)
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies
This posting is provided "AS IS" with
no warranties, and confers no rights.
Steve I had a chance tonight to publish a more complete Relationship
WIndow Layout tool. I was able to do add the functionality to copy the
Relationship Window Layout from an external MDB as I finally took the
time to decode the Layout BLOB. It was pretty straightforward. The BLOB
structure is documented below. http://www.lebans.com/saverelationshipview.htm
NEW - Feb 04/2004 http://www.lebans.com/DownloadFiles/...-RelationshipW
indowLayoutver6.zip is an MDB containing functions to:
1) To allow the saving of the layout of the Relationship window to a
table.
2) To allow the restoration of the layout of the Relationship Window
from a table.
3) To allow the saving/restoration of multiple Relationship Window
views.
4) To allow the importing of the layout of the Relationship Window from
an external MDB.
Private Type RECTL
Left As Long
Top As Long
Right As Long
Bottom As Long
End Type
' First 68 Bytes are the Header
' This is followed by (NumWindows + 1) * 284 bytes per record
' Last padding record seems to be padding
Private Type RelBlob
Sig As Long
AAAs(1 To AAAlength) As Byte
RelWinX1 As Long
RelWinY1 As Long
RelWinX2 As Long
RelWinY2 As Long
Blank As Long
FFFs(1 To FFFlength) As Byte
ClientRectX As Long
ClientRectY As Long
Pad(1 To Padding) As Byte
NumWindows As Long
End Type
Private Type RelWindow
RelWinX1 As Long
RelWinY1 As Long
RelWinX2 As Long
RelWinY2 As Long
Junk As Long
WinName As String * NameLengthMax
Junk1 As Long
WinNameMaster As String * NameLengthMax
Junk2 As Long
End Type
--
HTH
Stephen Lebans http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Steve Jorgensen" <no****@nospam.nospam> wrote in message
news:ld********************************@4ax.com... On Mon, 26 Jan 2004 15:42:47 -0800, "Michael \(michka\) Kaplan [MS]" <mi*****@online.microsoft.com> wrote:
"Stephen Lebans"
<Fo****************************************@linval id.com>wrote in message
news:AA*********************@ursa-nb00s0.nbnet.nb.ca... Just as an add-in to this thread there is a utility on my site that allows you to save/restore multiple views of the Relationship
window. http://www.lebans.com/saverelationshipview.htm NEW - Jan 21/2004 A2KSave-RestoreRelationshipWindow.zip is an MDB containing functions to Save and Restore the Relationships View
Window. Allows an unlimited number of different Relationship Window Views
to be saved.
Here is the Access97 version:A97Save-RestoreRelationshipWindow.zip
Very clever! Though you could have saved a bunch of time using the
built inAccess methods for storing different views by using the SysRel
utility Iwrote. :-)
Perhaps, I'm not understanding correctly, but I thought the SysRel
utility saved an internal Blob that represents the relationships. Is there
any way to know it's safe to restore those after changes have been made to the
tables and relationships since the time the Blob was saved? That had been my
concern.
I still think saving it in the actual Access format would be cooler. And
there is no shame in having an external library, you know!
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies
This posting is provided "AS IS" with
no warranties, and confers no rights.
"Stephen Lebans" <Fo****************************************@linval id.com>
wrote in message news:%d*********************@ursa-nb00s0.nbnet.nb.ca... Steve I had a chance tonight to publish a more complete Relationship WIndow Layout tool. I was able to do add the functionality to copy the Relationship Window Layout from an external MDB as I finally took the time to decode the Layout BLOB. It was pretty straightforward. The BLOB structure is documented below. http://www.lebans.com/saverelationshipview.htm
NEW - Feb 04/2004 http://www.lebans.com/DownloadFiles/...-RelationshipW indowLayoutver6.zip is an MDB containing functions to:
1) To allow the saving of the layout of the Relationship window to a table. 2) To allow the restoration of the layout of the Relationship Window from a table. 3) To allow the saving/restoration of multiple Relationship Window views. 4) To allow the importing of the layout of the Relationship Window from an external MDB.
Private Type RECTL Left As Long Top As Long Right As Long Bottom As Long End Type
' First 68 Bytes are the Header ' This is followed by (NumWindows + 1) * 284 bytes per record ' Last padding record seems to be padding Private Type RelBlob Sig As Long AAAs(1 To AAAlength) As Byte RelWinX1 As Long RelWinY1 As Long RelWinX2 As Long RelWinY2 As Long Blank As Long FFFs(1 To FFFlength) As Byte ClientRectX As Long ClientRectY As Long Pad(1 To Padding) As Byte NumWindows As Long End Type
Private Type RelWindow RelWinX1 As Long RelWinY1 As Long RelWinX2 As Long RelWinY2 As Long Junk As Long WinName As String * NameLengthMax Junk1 As Long WinNameMaster As String * NameLengthMax Junk2 As Long End Type --
HTH Stephen Lebans http://www.lebans.com Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit.
"Steve Jorgensen" <no****@nospam.nospam> wrote in message news:ld********************************@4ax.com... On Mon, 26 Jan 2004 15:42:47 -0800, "Michael \(michka\) Kaplan [MS]" <mi*****@online.microsoft.com> wrote:
"Stephen Lebans" <Fo****************************************@linval id.com>wrote in message news:AA*********************@ursa-nb00s0.nbnet.nb.ca...> Just as an add-in to this thread there is a utility on my site that > allows you to save/restore multiple views of the Relationship window.> http://www.lebans.com/saverelationshipview.htm > NEW - Jan 21/2004 A2KSave-RestoreRelationshipWindow.zip is an MDB > containing functions to Save and Restore the Relationships View Window.> Allows an unlimited number of different Relationship Window Views to be> saved. > > Here is the Access97 version:A97Save-RestoreRelationshipWindow.zip >
Very clever! Though you could have saved a bunch of time using the built inAccess methods for storing different views by using the SysRel utility Iwrote. :-)
Perhaps, I'm not understanding correctly, but I thought the SysRel utility saved an internal Blob that represents the relationships. Is there any way to know it's safe to restore those after changes have been made to the tables and relationships since the time the Blob was saved? That had been my concern. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Fred |
last post by:
Hi.
How do I import while mapping an excel table to an access table please???
I've searched around and all I can find is a software product or code that
does the same thing as the access...
|
by: Sami |
last post by:
Please bear with me, and if you answer this question, please do it
step by step. I am new at Access, not at all sophisticated. I am
using Office XP. This will need to be read in Access for...
|
by: Bri |
last post by:
Greetings,
I'm having a very strange problem in an AC97 MDB with ODBC Linked tables
to SQL Server 7. The table has an Identity field and a Timestamp field.
The problem is that when a new record...
|
by: WillieW |
last post by:
Hi folks,
I have Access 97 and have set up four tables, each with a Primary Key
with a file name manually entered. For example, the four tables relate
to information stored in a paper file, on...
|
by: yackel |
last post by:
Hi there, I'm just in the paper-designing stage of an inventory / sales
database but am looking for some help and suggestions as it seems a
little out of the norm due to the different classes of...
|
by: James |
last post by:
I am used to VB6 but need to develop something in .Net.
I need to create several bound combo-boxes which will use lookup tables to
get their values.
I created a form using the dataform wizard....
|
by: phil-news-nospam |
last post by:
Is there really any advantage to using DIV elements with float style
properies, vs. the old method of TABLE and TR and TD?
I'm finding that by using DIV, it still involves the same number of...
|
by: sara |
last post by:
I have been working this idea for a little over a week now and am not
convinced I have a good solution.
I have a little system that tracks Purchase Orders (POKey autonum,
PONum are both ont...
|
by: TonyJH226 |
last post by:
I’m using Access 2003 and am a novice to Access.
I am creating a form to facilitate data entry to seven tables. The main table (A) has four sub-tables that are related to the main table by...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
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,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
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...
| |