Double Byte Data

I have a double byte data (chinese characters) in my database but they appear as ASCII characters. I already installed language pack. What should be the data type of my field names in order for the chinese characters to display properly? Coz in SQL server, the data type of the fieldnames with chinese characters must be nvarchar. Maybe, it's the same thing with access? Help me pls...

View Replies


Big Endian Byte Order Type Of Data - How To Read Them - Version: 2002 (10.0) XP

How do I successfully read a field of data-type Double (Signed 64-bit IEEE double-precision floating number Big Endian Byte Order). I would like to read it off a file before assigning it to variable of Double data type?

Similarly, how do I achieve the same task but for a field of data-type Integer (Signed 32-bit integer Big Endian Byte Order).

I ask so because I have the challenge of opening a file with a mixture of fields; some in Little Endian Byte Order, and others in Big Endian Byte Order. I have correctly read the ones in Little Endian Byte Order, but not so with Big Endian Byte Order as some values which I know to be positive are coming-out as negative values.

Any AID?

View Replies View Related

Select Data From Double Clicking

Hi all, I have a query to recall all the events related to a certain employee by running a query and inserting the staff number, I then have a form showing the details of all employees; what I need is to add a button on the form that runs the mentioned query without having to insert the staff number again as the form is already showing that employee.

View Replies View Related

Double Data Entry - Version: 2003 (11.0)

Hello there

Can anyone tell me a simple method of creating an application in Access 2003 that uses "Double data entry"? For me double data entry is defined as the ability to have data entered twice. The first entry is entered into the database, the second entry is checked against the previously entered data, discrepancies noted during second entry are communicated and during the second data entry there is an option to correct or accept either value. The end result is one database that is a higher quality based upon two independent entries of source data into the database.

I have created a sample database that has a Switchboard form (Main Switchboard) which opens the same form (Form1) in “Edit” and “Verify”. I request for somebody’s help with VBA code to enable the verify mode of form, according to the requirement as mentioned above. I have been struggling to do this for long time, but in vain. Any help in this regard will be highly appreciated.

Thanks in advance for all your help.

View Replies View Related

Moving From 1 Data Base Entry To Another By Double Clicking

I am new to access and all of this and trying to create a database to record livestock (budgerigars) I have put in the reletive informnation for 2 generations but would like to beable to click on a record in forms view and for the grandparents to be automatically inserted. Something like a family tree.

Also I would like to be able to double click on a entry which shows as a parent in a form view, and for the database to go directly to that entry and bring it up onto the form.

I hope someone can help and that I'm making so sense

(anyone know a good book that would help me understand all of this)



View Replies View Related

Single Vs Double Numeric Data Type - Version: 2003 (11.0)

Hi All,

I'm racking my brain here...I'm storing fractional measurements in my database where the range is usually from no more than .25 to no less than .000001 (1x10^-6), but possibly .0000001 (1x10^-7). With that in mind, I should be able to store my measurements as a Single, right? But then I read that today's computers work better with double floating point data types. Weighing size (4 bytes vs. 8 bytes) vs. computational speed and query speed, can anyone tell me what my best bet is, Single or Double.

Thanks very much in advance,


View Replies View Related

Trying To Import Data As Text, But Access Changes It To Double? - Version: 2000 (9.0)


I have an excel data file that I want to import to MS Access. The first field is a Security ID, alpha numeric, with a general data type.

Here's some examples of an ID:
1. "5302307"
2. "M055870"

However, when I import the file into Access, the data type of the field changes to a double, which of course causes data errors, especially for the alpha numeric data.

My question is, how do I tell Access to not to change it to a double data type. I tried going into Excel and change it as a "Text" data type and tried importing again, but Access is still changing it to a double.

any help with this regard is greatly appreciated,


View Replies View Related

Double Click On A Record In Datasheet Opens A Form To Enter Data

I have a list of incidents in my Incidents Management Database. It comes up as a grid view when users open the database.

This is what it looks loke (paste the following into address bar of your browser.

I want particular incident to open in a form when users double click on any particular incident from the list above.
For example double clicking on the first incident (dated 1/03/2008 in the list above) should open the form below with THAT PERTICULAR incident. And double clicking on 22nd incident should open the following form with 22nd incident loaded, so users can edit that incident

please Paste the following into your browser to see the image.

Any detailed help is much appreciated. – I am too new to understand macros and vba.

View Replies View Related

Whats The Diffrence/meaning Of Single Double Data Types - Version: 97 (8.0)

I have been creating databases for a few years now and I always choose single or double and have never had problems. When I look up an example to decide which on to choose it gives me some number with an e or an f in it. I have never counted with letters so this means nothing to me. Could someone please explain this in simple terms what is a single and what is a double so the next time I create a database I will know exactly which one to choose.


View Replies View Related

Double Quotes In Data Causes Command Object To Fail. - Version: 2003 (11.0)

I'm using a command object which runs a query to populate a temporary table. Unfortunately the data which is returned contains some double quotes.

The query runs fine on its own, just fails when called within the command object.

Anyone have any ideas how to work around it?

This is the code sample.

With cmd
.CommandText = "qryIT_Proxies_Added_FDB"
.CommandType = adCmdUnknown
.Parameters.Append .CreateParameter("prmAsOfDate", adDate, adParamInput)
.Parameters("prmAsOfDate").Value = EnteredDate.Value
.ActiveConnection = CurrentProject.Connection
End With



View Replies View Related

LOF Function Returns Incorrect Byte Count (but Windows' Fault) - Version: Any Version

Today, and about twice in the past, I'm experiencing that Windows is mis-representing the number of bytes contained in a text file that I create in the C:Windows folder. When I right-click on the file and view its properties, Windows shows 60 bytes but there are only 30 text characters in the file. The file is created by code. If I manually create the file using Notepad and view properties, the byte count is consistent with the number of characters (30).

The LOF function returns 60 bytes, I guess which is consistent with what Windows has for the file's property setting. LOF returns 30 on the manually created file.

Using "Refresh" in Explorer does not force a refresh of the byte count. What's a good work-around to this problem? Thanks.

View Replies View Related

Double Access

I have a realy serious problem that when I open msaccess (I have access 2003) and I'm trying to reach the database from my application, the application fails to get to the database. Aparently this happens because access is opened but isn't it supposed to allow multiple access to the database?

Anyone knows why?

Thanks in advance.

View Replies View Related

Help With Double Booking

Please could someone give me help on this topic, I need to slove it for coursework in Access but im having the following problem.

Im creating a database for a hotel which rents out its room obviously. The problem i have is if a guest books a room for say march 3rd until march 6th, theres currently no way in which to stop another guest booking the room for any of these dates.

I think i know how to stop double booking for the start day, but not the days inbetween if you understand.
The database has 3 tables:
Guest Info
Room info

If anyone can help it would be greatly appreciated.

P.S the method i hope to use, is the hotel will enter the start date of a guests stay and then enter the number of nights the guest is staying for e.g. 3rd-6th of march would be input as: Begin date: 03/03/08 for:'3' nights.

Thanks for any help

View Replies View Related

Double Bookings

hi guys nice site you got here.

I need a bit of help its been over 2 years since I used access in college so have forgot most things.

I want to stop people from making double bookings at the same time on the same date.

I have the following

Booking ID
Teacher ID
Class Room ID
Date Booked
Booked Date
Start Time
End Time

so the booked date, start time and end time is what I need to look but not sure, should I index (no duplicates) for them three?

thanks for the help

I realise there are posts about bookings but more help would be great :)

View Replies View Related

Calculate Double OT

stuck in the middle of a project of employee payroll the following problems are for some suggestions:

if an employee is not taken off in a week and work on sundays, he's paid double OT; if he is not taken off he's not paid; i.e. he can take 4 days off in a month

how can i keep track of this in the db; can i use a table putting 7 days as fields and make it all yes/no so that user can check or uncheck the status against each employee(!); but for whole month how can i calculate

work period start from every month on 25th and ends on 24th in next month.

got tables for attendance and leave

help appreciated

View Replies View Related

Double Booking HELP

I am wanting to prevent a double booking. I have a form called:

frm_Booking which records an ArrivalDate and DepartureDate

and another form

frm_Building_Booking which records a BuildingID number

I want to ensure that a customer cannot book a BuildingID for an ArrivalDate and DepartureDate it it has already been booked by another cusotmer or book any on the days between.

However a customer should be able to book a BuildingID on the DepartureDate.

View Replies View Related

Add Record On Double Click??

Morning, all...

Hoping someone can help me with this. I have a form (one-side) with a bound continuous subform (many-side). I have a second unbound subform, also continuous, which is used as a reference only (no data entry) to select the record to be added to the bound subform. Is it possible to set it up so that, when the user double clicks on the pk from the unbound subform it adds that pk as a new record on the bound subform?

Thanx in advance for your help with this ;<)


View Replies View Related

Double Entry Accounting

I have been searching the web for some examples of a double entry accounting systems made with MS Access. I havent found any that I can open... examine the tables, queries, relationships and everything else. Not that I am planning on spending a year or two building one :) But I want to know how to. So if anyone knows of any good examples please post the links for me. Thanks

View Replies View Related

Double Entry Accounting DB...

I'm looking for someone who knows a bit about this one... maybe done one before. I've started a DB for an accounting system, I've worked with MANY of these over the years, but from a user standpoint. Now I'm trying a shot at putting one together, just for a learning experience if nothing else. But I would like someone to take a look at the beginning structure of the DB and let me know if I am on the right track. Any input and suggestions would be helpful and appreciated. Keep in mind there is ALOT not here yet... and some loose tables for future expansion. I didn't want to get too deep into it and find out I need to make a major change. I'll post the DB.

View Replies View Related

Double Booking Suggestions

I am currently developing a database as part of a school assignment.
The database is supposedly to be made for an internet cafe.
I have already coded a good part of the database; time limits for certain days, at least a day in advance booking, no more than 50 computers are allowed to be booked at one time, etc.

I am currently running into problems trying to code double booking prevention; no more than 50 computers are allowed to be used at one time.
I am guessing a will need some sort of booking slot that uses a combination of the fields, but I'm not sure what.

(I also have a client details table/form which is running OK)

Booking table fields:

I appreciate all suggestions and I will try and test all of them.


View Replies View Related

Double Click To Paste

I want to lookup a list of employees (in a form) and by double clicking a name listed, have that name pasted into another form or Sub form to add details to it.

I want to select a number of employees and add info such as attending a training session, plus the topics covered, instructors name etc. I want to add this info once but relate it to a number of employees who attend the training???

View Replies View Related

How To Eliminate A Double Quote

I have a string with one or more double quotes in it. How can I remove the double quotes? (I was able to remove single quotes.)

Example: Purchase "other items". (This the data in a column.)

I want to change it to Purchase other items

View Replies View Related

Pls Help, Double Booking Problem.

could someone please help me, i am having a problem trying to get rid of double bookings in the attached database.

This database is for an assignment for my students, and unfortunately i had got the point now that i have got incredbily stupid and cannot see a solution.

I want to make sure that a client cannot double book an instructor and a car on a specific time or date...

Obviously i would also want to make sure that if one client has booked a specific car or instructor no other client would be able to book it, in the same time and date slot.. All lessons are 1 hour long

for some reason i have to make sure that a client can book a specific car...
This unit is being taught alongside another unit by another teacher, who does not see the complexities of the problem, and insists that this complexity is in the database, however they do not know the solution either.

I have tried creating different types of primary key combinations, but that does not work..

Any ideas or suggestions would be greatly appreciated

View Replies View Related

Confused With A Double Inner Join!


I'm trying to do something really simple here but I'm getting confused with the correct syntax.

I am trying to retrieve a list of data from 1 table (tblUsers) and 2 queries (spPFApprovedThreads, spPFApprovedEntries)

From spPFApprovedThreads I would like to retrieve 'Thread' and 'CreationDate', from spPFApprovedEntries I would like to retrieve the a Count of 'EntryID' for every 'ThreadID' and from tblUsers I would like to retrieve 'Username'.
Where tblUsers.UserID = spPFApprovedThreads.CreatorID and spPFApprovedEntries.ThreadID = spPFApprovedThreads.ThreadID

I have managed to do the following:

SELECT t.ThreadID, t.Thread,t.CreationDate, count(e.EntryID)
FROM spPFApprovedThreads AS t INNER JOIN spPFApprovedEntries AS e ON e.ThreadID=t.ThreadID
ORDER BY t.ThreadID;

but how do I add the Username from the tblUsers?

Many thanks for any time.


View Replies View Related

Format Double Question


I have been asked to run a query on an existing db and output certain fields as type Double.

The fields in question are currently type Currency.

How do I change the format from Currency to Double or do I need to?

Thanks in advance


View Replies View Related

Problem With Double Join

I've done double and even triple joins before, but this isn't working for me, probably because I'm using a SELECT statement instead of a table. Here's the basic (working) query:

SELECT Employee.*, NewPositionID AS [Position], NewStoreID AS [Store]
FROM Employee
[Position Change] INNER JOIN [Store Change]
ON [Position Change].EmployeeID=[Store Change].EmployeeID
) ON Employee.EID=[Position Change].EmployeeID;

Now that works perfectly fine, but the problem is I only want the employee to join with the most recent position and store change. So I tried something like this:

SELECT Employee.*, NewPositionID AS [Position], NewStoreID AS [Store]
FROM Employee
(SELECT TOP 1 * FROM [Position Change] ORDER BY EffectiveDate Desc)
INNER JOIN (SELECT TOP 1 * FROM [Store Change] ORDER BY EffectiveDate Desc)
ON [Position Change].EmployeeID=[Store Change].EmployeeID
) ON Employee.EID=[Position Change].EmployeeID;

It tells me "Syntax error in JOIN operation" and it highlights the first occurence of "[Position Change]" (the part in bold). Using the 1st query I don't see how I can filter out the correct records.

View Replies View Related

Double Entry On Forms?

Hello All again,I am working on a form for my database this time and I have noticed something odd that I cant figure out. I have managed to make the following form ( from a Staff Table, Activities Table and a Total Expense Query, all in the one form. My problem is that I only have two entrys in the activities ( but I am recieving 4 entrys in the form. 2 of witch the totals do not add. (see other 2 entrys here: Does anyone know why this would be happening?

View Replies View Related

Form Has Double Vision

Does anyone know why on my form that the first line looks like it is double vision? The label and the control look like I inserted it twice. But when i click anywhere on the form, it goes away and looks normal.

View Replies View Related

Double-click Name To Add To Adj. Listbox

I have a list of companies in a table which Is being accessed through a list box. I wanted the user to be able to double-click on the name of a company from that long list and then for that selection to show up on an adjacent shorter list box which in turn will be used for a search. How can I do this? Another option would be to drag and drop the name from on list to another.

View Replies View Related

Double Click Event


I have a form which has a tab control on it. The form itself is based on 1 table (tblCustomers). The tab control has 2 pages.

Page 1 shows 6 fields from tblCustomers.

Page 2 of the tab control shows 2 embdedded forms. Those forms are based on queries created from tblCustomers. one shows records with a date entered into one of the fields, the other shows records that have no dates.

What I want to be able to do is when I see a company name in one of the ebedded forms (Page 2), I want to be able to double click that record and it switches me back to Page 1 and shows the the related details of whichever company I double clicked.

I have changed the double click event in the emdedded form and using the builder to create something. I also added a setfocus command as I read about that somewhere (but i have no idea what it does). Through this I managed to get it to switch from Page 2 to Page 1 when I double click, but it only ever takes me to record 1 regardless of which company i double clicked.

i may have this deisgned totally wrong so please feel free to point me in the right direction.

any ideas?

thanks in advance

View Replies View Related

Cant Get Double Hyphen (--) To Work!

I cant get the comment feature to work in SQL. If I type the following...

Code:SELECT * FROM tblMembers WHERE OrderNo='xxxx' -- Finds the member

An error message is returned saying 'Syntax Error (Missing Operator)'. What am I doing wrong?

View Replies View Related

Double Sided Print

Hi, Can you tell me how to print double sided in MS Access?


View Replies View Related

Double Sided Page Break

Hey, I tried searching for this one, but I'm not really sure what to search for.

I am running a report that is double sided. However, I do not want the start of the next group, on the same physical page. I also do not want a starting blank page (as I thought about inserting a blank page after the section).

Any way to do this?

Maybe I have to write a function or something? Depending on if the page is an even or odd number? I honestly have no idea.

Thanks for the help!

View Replies View Related

Copyrights 2005-15, All rights reserved