|
by: Jeff |
last post by:
Ok. I am creating a table in an access DB based on a form submission. This
works fine. The problem I am having is, if there is a space in the
submission. For example.... someone submits "The Island"
when the asp script uses SQL to create the DB, it creates it as "The" only.
SO I am guessing it stops when there is a space in the name. Is there some
way to get around this??
Jeff
|
by: Jerome |
last post by:
Hi, I'm a bit confused ... when would I rather write an database
application using MS Access and Visual Basic and when (and why) would I
rather write it using Visual Studio .Net?
Is it as easy in Visual Studio to create reports and labels as it's in
Access?`
The advantage of VS.net is that not every user needs Access, right? And
that would eliminate the Access version problem as well I guess.
|
by: Arsene Lupin |
last post by:
Is there a way to have Microsoft Access XP automatically display all
table views, etc., in a maximized screen when Access is started? It is
extremely time consuming to have to maximize the viewing windows
inside Access every single time I started it.
Thanks in Advance.
|
by: None |
last post by:
Hi,
I have an excel spreadsheet which is a list of my drawing numbers.
I have seperate tabs for stuff like mechanical drawings, circuits, and PCB's
and such like.
If my last drawing number was a mechanical drawing it will be say M1234.
If I now want to do a circuit I will choose C1235. The PCB that matches
C1235 will be PCB1235.
I may have an F2345 which is a filmwork drawing, and an E2345 which is an
engraving drawing for the same...
|
by: stoppal |
last post by:
I have a sql statement:
"SELECT Field1,field2 FROM table WHERE field1="!"
I need to export this to a CSV file with header information.
How can I do this?
I've tried the below function "save_data()", but I get a "expression
expected 1 error", I think b/c text transfer does not support
|
|
by: joshtichauer |
last post by:
So i have an xml file, i'm grabbing it via dataset, then placing the
data into a datagrid. everythings all good, but i'd like to edit the
data. the coding grabs whats in the edit textboxes, and should throw it
back to the xml file, but i get an error
"System.UnauthorizedAccessException: Access to the path
"c:\inetpub\wwwroot\work\xmlfile1.xml" is denied.
ASP.NET is not authorized to access the requested resource. Consider
granting...
|
by: Hexman |
last post by:
I've been trying to figure ADO.net/VB/AccessDB out for some time.
I've read many internet articles that have been pointed out to me by
people in this group. Thanks for trying to help. I just can't get
it. All I'm trying to do (in pseudo code) is:
Open a table in Access.
read a transaction from flat file until eof
Build a query ("Select * from purord where ponum = 'flat file
ponumber' ")
execute query
|
by: Shun |
last post by:
Hello,
Please anybody try to execute this code. I am having a "quick.html" with
email Id and name etc..., and henext form is the below "gdform.asp".
When i try to execute this i am getting the following error. Error 70 :
Access Denied.
Please anybody can help me.
|
by: Navymike |
last post by:
I have a query that displays ProgramType and a new field call Total that will display the total of all member’s MonthlyFee for each young adult program?
Any help would be appreciated
Navymike
|
by: mikkaro04 |
last post by:
hi.. i have a problem about date comparison in VB 6.0 and MS Access
i want to compare dates from access to a date from DTpicker control in VB 6.0.. this is my code but it doesnt work coz i get a syntax error..
"Select * from Reservations where DateCheckIn <= #date1# and DateCheckOut > #date1# and = ' " & cmb_room & " ' "
"Select * from Reservations where #DateCheckIn# <= #date1# and #DateCheckOut# > #date1# and = ' " & cmb_room & " '...
|
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: 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: 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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
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...
|