I have recently upgraded my Access 2003 application to Access 2010. I am running into a problem when formatting a textbox to 'Long Time' that is linked to a Double type field. The error that I get is 'The value you entered isn't valid for this field. You may have entered text in a numeric field or a number that is larger than the FieldSize setting permits.'
The textbox is linked to a field (double data type) and displays as the time in long format (4:06:17 PM). When I try to change to 4:07:17 PM I get the error. I tried removing the 'PM' and the colons but the error still occurs. The only way that I can get it to work is if I use a double value (0.735405092592593). In Access 2003 the time value would display properly, allow me to change the time and then save the time as a double to the database.
I have been trying to convert string into double number format. I am running a SQL query in VBA that returns a double number format; however my understanding with SQL queries in VBA is that they return string only. The results are showing up perfectly fine when I run the query in the query editor; however when I try using the returned value in further calculations in VBA I keep getting a "Type Mismatch" error.
I wanted to assign the field "Number of magazine" with special format based on date/time format but showing only year and month in the format: "yyyy-mm".
So in property of this field in format I put yyyy-mm and in input mask I type 0000-00;;-
I also created the form based on the table containing above field and I defined format and input mask for corresponding formant in the same way like at the table.
But if I try to type date for example 2014-01 in text box of the form it comes up with the full date 2014-01-01. Why does it do like this? What do I do incorrectly?
I have a list of dates in the mm/dd/yyyy format and I am looking to get it into the fiscal format of yyyyww. I am able to do this with the datepart and format functions, but I need to make it so that the fiscal month begins in January but the first week starts if there are three or more days in the week. For instance if Jan 1st is a Friday then this stands as the first fiscal week, if it is a Saturday then it does not count as the first week.
datepart and format functions have the Use the first week in the year that has at least 4 days for the firstweekofyear option but I need it where it has at least three to make it work.
I am exporting data from access 2007 to Excel 2007 using VBA code. I have a whole number, which I want displayed as whole number. But after the export, the number is using the 1000's seperator in Excel. So for example if my original number in access table is 12000, it is showing up as 12,000 in the excel file.It has something to do with the NumberFormat property. I have tried doing this but doesn't work.
We're using Access 2010 on Windows 7.We have a large database design where we send reports as e-mail attachments. We need to change the way the file is automatically created when sent. I goes to snapshot form every time we attach it to an e-mail. How can we get rid of the snapshot .snp file format? How can we change it to pdf or accbd?
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.
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.
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 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?
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.