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...
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.
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. Thanks Marco
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.
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)
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.
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.
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. lh5.google.com.au/snehal.dabhi/R8oc22J_RfI/AAAAAAAABz0/bbIkCzg5whk/image001.png
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. lh6.google.com.au/snehal.dabhi/R8oc3GJ_RgI/AAAAAAAABz8/vGSjfr5rZ10/image003.png?imgmax=640
Any detailed help is much appreciated. – I am too new to understand macros and vba. Thanks!
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.
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.
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?
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 Bookings
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.
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.
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?
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
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. Thanks Curtis
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)
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???
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
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 GROUP BY t.ThreadID ORDER BY t.ThreadID;
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 LEFT JOIN ( [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 LEFT JOIN ( (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.
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 (http://members.iinet.net.au/~a.beardsley/database/1.jpg) 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 (http://members.iinet.net.au/~a.beardsley/database/3.jpg) but I am recieving 4 entrys in the form. 2 of witch the totals do not add. (see other 2 entrys here: http://members.iinet.net.au/~a.beardsley/database/2.jpg). Does anyone know why this would be happening?
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.
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.
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.
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.