|
by: Matthew Wells |
last post by:
I have a a parent form with a subform. The parent form has two command
buttons to change the subform view to single form view and datasheet view
respectively. I can't seem to get this to work. There is a menu item to
switch to datasheet view, but it won't go back to form view. The only way I
see so far is to open the subform by itself in design view, change the
default view, save & close, then set the sourceobject property in the main...
|
by: Richard Sherratt |
last post by:
I added a new field to a table in the tables database. In the code
database, I added a new column for the new field to a datasheet
subform. I opened it in datasheet view and moved the column to the
position I wanted it. No records are returned by the form's query (it
has a "Where ID = -1" clause and the GoToRecord proc on the main form
changes the subform's recordsource).
When I opened the form and started adding data to the subform,...
|
by: Paul T. Rong |
last post by:
Hi everybody,
This time a very very difficult case:
I have a table "tblStudent", there are 50 students, I also made a form
"frmStudent" based on "tblStudent", now if I don't want to show all the
students in a classical (vertically, from top to bottom) way, but make them
"sitting" in 50 text boxes, 5 rows 10 columns, how to do it?
Thanks in advance.
|
by: steph |
last post by:
Hi,
A question regarding Access 2002:
I've got a form which should be displayed in Form View and in Datasheet
View. But I want to use a different record source for each view. That
means, when the view is switched I want to switch the record source
also.
I tried to put this functionality on the "On View Change" event, but
|
by: Simon |
last post by:
Dear reader,
In a form with the property "Default view" as DataSheet I like to hide some
fields in the datasheet view.
It is possible to manage this with the command Format>>Unhide columns, a
form pops up with tick boxes to hide or unhide the columns.
|
|
by: ghat12 |
last post by:
Hi,
I am trying to print a subform containing approx 50 columns in
datasheet view. The printout cannot fit more than 8-10 columns. Does
anyone know of any way to print all columns; i don't care if the
printout spans multiple pages.
FYI, the records displayed in the sub-form are dynamically obtained
based on some ad-hoc querying in the main form. Any report, etc.
generated will have to have the same set of records.
|
by: fh217 |
last post by:
Hi
I have a datasheet with 32 columns, the first 2 columns are frozen
and disabled. What I would like to do is as a user tabs thru a row
on the sheet is to shift the sheet to the left so it becomes the first
column next to the frozen columns ( column 3 ), also if the user
back tabs the sheet would shift to the right. I am doing it now by
setting the columnwidth of the column being tabbed out of to a
width of 10 and when it gets focus...
|
by: Simon |
last post by:
Dear reader,
In a datasheet form you have the possibility to hide or unhide columns.
But in case the datasheet form is a sub-form this functionality is not
longer available.
|
by: aas4mis |
last post by:
I have two textboxes in my main form that I use for default information. (purely to save keystrokes for the end user). They are txtInv (invoice number) and txtSlj (date invoiced). My subform in viewed in datasheet mode (has fields "invoice" and "slj". I know it's possible to update a subform with information from the main form when viewed as a form but how would that be done when the subform is viewed as a datasheet?
|
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: 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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
|
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: 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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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: 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: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
|