I have 2 tables tblComputers & tblComputerAllocations
tblcomputers has 85 records & tblComputerAllocations has 71.
I would like a query that returns the 14 computers that have no allocations.
I tried a union query on field ComputerID but i must misunderstand its use!!
Thanks in advance,
Phil.
I have a simple UDF that takes a string and returns a variant, which is an array of strings Example Input "Brick Wall" Return value would be a variant array with first element "Brick" and and second element "Wall" Now I have a table with a field of strings, and I want to make a query that returns all the results from the function, one per line.
So if my input table looks like this
[strField]
"kick the ball"
"return the pass"
my query result should looks like this
[Orig] [new]
"kick the ball" "kick"
"kick the ball" "the"
"kick the ball" "ball"
"return the pass" "return"
"return the pass" "the"
"return the pass" "pass"
Last time I had to do something like this I used VBA exclusively, with ADO objects, but I thought a query based solution would be easier.
With my current data the largest return array size my function returns is 27 elements but I wouldn't want to rely on that number being fixed.
Im creating a db to keep records of computers that have been assigned to persons in their various departments and also unassigned computers and spare parts.
problem:
For the machine specifications table should i put in the following fields as columns
Hard Drive 1
Hard Drive 2
Hard Drive 3
Optical Drive 1
Drive 2
Drive 3
or should i just create a field called Component and another field called type/size e.g. component would be hard drive or opticqal drive and Type/Size would be 60GB or DVD+RW
or should i just create individual tables to store the Hard drive info separate from the optical disk and separate from the memory.
The database is going to get really big which is why i wana structure it properly you r help would be really appreciated.
Is there a way to dynamically allocate a certain range of days if I know a start day?
I have a form where I have a date called startofproject and I want to allocate all work week days from that start date + 90 days.
I’m assuming it should be some sort of make table query that will delete all data in it and create a whole new range of dates when I run the query again.
Is there a way to do that?
Thanks.
I'm working on creating a resource allocation table for my small company. Basically, we want to be able to designate a certain number of "man-months" per functional group per month per project. Additionally, this database will hold the billing milestones that are associated with the project and we will track some health indicators to each of them.
For instance, we may have a project that is going to be running from May 15th 2014 to June 5th 2015. Based on an access project template I found, I have created some pretty good quality forms/tables that are working well for project inputs and milestone tracking.
Project Table
Lists the Project Name, Project Manager, Priority, Status, Start Date, End Date, and some baseline budget info.
Resource Groups
Lists the functional groups (Electrical Engineer (EE), Mechanical Engineer (ME), etc.) There are 9
Milestone Table
Project, Title, Priority, Status, Client Billing Amount, Schedule Risk, Technical Risk, Owner, Start Date, Due Date, and some budget lines and descriptions
Alright, So I can't for the life of me figure out how to structure the monthly allocations in a usable table/form. This is what I would like it to look like, similar to the excel document we used to track it in.
How can I create a table that will store all of the data (Project, Resource Group, Month/Year, and Man-months) with inputs from a form that will automatically show the relevant months (between project Start Date and End Date)...
:confused: Guys I need some help!
I am new to this database stuff and my work want me to produce a database which will not only keep stock on printers, scanners, monitors and base units we have in stock but want an allocation system as well.
Basically, a member of staff from a department will make a request for some items. These could be a monitor, 2 base units and a scanner for their location. I need a system which tells the user that the items or qty they want is in stock or not. I know I need to use an unbound box for this but dont know how.
Then I need a form which a IT techie can allocate a job too themseleves and take the item to them once this has been done they sign off the job.
I have a rough idea on what I want in each table but I am really losing time and i need some help or if anyone can do a quick one for me with forms etc I will be ever so grateful!
The tables look as follows:
Dept - DeptID, Name of Dept
Staff - StaffID, Name, Postion at college
Request - RequestID, Date, StaffID
Stock - StockID, Item (monitor), make (CTX), Model (17" TFT), QTY, Status (dead, working, faulty)
Request deatils - ? - Basically this is where the staff member will make their request for what they want.
Allocation - This part needs to be given to a member of staff and they needs allocating out
Techie - TechieID, Name, Postion
Location - LocationID, Location (where the item is going to)
If anyone can help me please post otherwise please please send me an email to mini_beest@yahoo.co.uk
Thank you and hope you can help
How could I create a single table (matrix) type input view to allocate bank transactions to categories, noting one transaction can be allocated multiple categories with an associated percentage? What approach should I use in Access to get this? So say I have the following tables:
* Transactions
* Business Category
* Transaction-Business-Allocation (which includes)
- Transaction ID
- Business Category ID
- Percent Allocation
But in terms of the means of reviewing bank account items and allocating I really want a view like this (see attached image)The specific business category could be either selected specifically, or all included.
I have a Form created for Hardware Allocation.
I have following Fields. Allocation ID(PK), HW ID, User ID, HW Status, Assigned Date.
Values of HW Status = Active, Inactive, Decom, In Stock etc.
What I want is explaind below example
HW XXX is allocated to User ABC and the Status is Active.
Now When I want to reallocate the same HW XXX to Another User XYZ then Make the current status as Active. But before doing that the form should force me to change the Status of previous allocated to user ABC to anything other than active. Because One Device can be active to only one user at a time.
i,e Combination of HW ID & HW Status(Active Only) should not be duplicated.
I have a program thats work perfectly in some computers useing the network but when i try to open it in other computers i get an error and when i try to debug the error it highlit the line that i am calling the micro that open the mainform in it, i hope some one have an idea for what is going on with the program
View 12 Replies View RelatedHey, My access database will be used to make computer reservations for an internet cafè. The user makes their reservation date by using a calendar control, they choose their start and end time, and they also choose the amount of computers they can book (no more than X). Would it be possible to create a query that will limit the user from overbooking the computers?
View 14 Replies View RelatedI created the database on my computer. I added security and split the database to put the tables on the the server. Everything works just fine on my computer. However, when I try to copy the 3 files for the front end of the database to other computers on the network, it won't work.
Perhaps I'm confused as to what files need to be migrated to each additional computer or I don't have the security setup properly.
Right now, I move 3 files. The main database file with the front end. The shortcut file that is created when you add security and the security file that is created when you add security to the database.
I'm stumped.
Well...here's the deal. Four computers were replaced in our office and now three of them are having problems with the database. The database is written in Access2003 and all computers (the old ones and the four new ones) are running on WindowsXP Professional w/ Office 2003.
The problems that comes up only involves reports (viewing, email, exporting). When they try to view a report, a message comes up
Cannot find object ".
When they try to email or export a report the function is cancelled due to the error.
I'm going to have the computer admin re-install Access to see if that helps.
I've been searching around trying to find some info on various settings that would cause this, but I'm pretty ignorant in this arena. I checked the references in Access and they are both the same. That's about the extent of my knowledge in thise area.
Any insight would be great.
Thanks for the help.
BB
Hello All,
I have MSAccess ade working in some computers which has WindowsXP-pro(SP1 and SP-2) without any problem. But It doesnot work(When i said it doesn't work means it doesn't work in certain parts which i will give an example) in some computers that has exact same configaration. The problem is when I try to instance a class using a TypeName function, it doesnot recognize the class name and just returns an object rather than recognizing the class's name. Its a strange thing because I have some .ade from past works fine in all machines. The only difference is In the new .Ade is I have included the Microsoft outlook 11.0 object library. But the part of the code thats not working doesn't even use the Outlook library at all. So did anyone has this kind of problem, PLease suggest or ask me if you have more details of this problem. I really appreciate your help.
Thanks again
ds111
Hi,
Hopefully this is a really simple requiring a simple answer.... hopefully
On one of my forms I have a combo box thats values are generated by a parameter query. On my computer and a couple of others i tested it (on the same network) this combo box populates fine, but i put it on a couple of other computers today and it doesn't show any values. I checked and the query itself runs fine, plus a combo box that runs off a table populates fine.
not too sure if its relative but the database is split with the tables sitting on the network share and the database sitting on the main computer. or perhaps this could have something to do with blocking unsafe expressions.. i am not sure
any help on this would be greatly greatly appreciated
Does anyone know/how my forms' background colors are different from one computer to another? The computers that are showing the correct color are both XP and Access 2002 (one is a laptop and one is a desktop)... but then someone else.. on a laptop (with XP and access 2002).. the forms' background colors are not good (purple)... vs. blue on my laptop and the desktop. Thanks!
View 3 Replies View RelatedI have a report that was created on my computer. When this report is opened on other computers (2 that I've tried) the text alignment is way off. Originally I thought it had to do with printer margins dictating something but that is not the case as the margins remain identical on all computers. It's not a font issue because it's Arial which all computers have. The text is written inside a "label".
View 5 Replies View RelatedI design/maintain an Access database for a friend's business using my home computer. The printer he uses allows for much smaller margins than mine does, so anytime I edit a specific report that uses very small margins, my computer automatically increases them to the minimum margins my printer allows and when the business owner runs the report on his computer it spills on to extra pages.
Right now every time I make a change, I need to go directly to his computer and adjust the margins within the report after the new front end is uploaded.Is there any way around this, such as telling Access to ignore the printer's minimum margins?
I recently completed a database project and was set to launch it today for use throughout the company. The database is split, and both ends are saved in the same folder on the company server. I have copied a shortcut to the front-end file onto the desktop of each of the four user computers. Two of the four users are able to open and operate the front-end with no issues. The other two won't run the 'Default Value' formula for the "Order#" field in the front-end form. This being the case, I'm certain this is not a code issue.
Form
- Field
- Control Source
- Default Value
PO#
= [YEAR] & ["P"] & [Order#]
N/A
[code].....
When I opened the form on the two noncompliant computers the PO# field displayed #Type!.I deleted the Order# default value to confirm that that was indeed the source of the problem, and it is. When deleted, the PO# field displays "13P" instead of "#Type!".
I've tinkered around with Trust Center to no avail. And I'm almost certain this is not an upgrade/patch issue as one of the nonconcompliant computers had Access 2010 downloaded yesterday. The server and all users have Access 2010.As well, the option settings on the front-end are set to only open the form, with no editing capabilities. However, when using Shift+Enter to open the edit capable version, there is no issue; the PO# populates.
I have an estimating database, the "main" database is on my desktop, then it is also on a Notebook and Laptop and goes out with the bidders. At the end of the day, I want to sync all 3. I may enter info throughout the day on my desktop (which needs to sync up to the other 2) and vise versa. Using SharePoint is not an option as the Notebook and Laptop will not always have internet access.
View 1 Replies View RelatedI have completed a database for a company with 60 000 clients and over 100 000 job records.
The database works at very resonable speeds on the Server computer, or the computer on which I installed the back end of the database.
Each of the other 3 computers on the wireless network, have a local copy of the Front End on their machine, and reference the Back End (BE) on the server computer.
Each of the Client computers have varing speeds when accessing the BE, some as slow as 10 minutes for a simple search, filter or just loading a form.
What can I do to improve performance across the network?
Do I need to install additional components on the other computers to improve the db performance?
Your help will be much appreciated.
Joseph.
I have a report (Access 2007) with subreports that is being exported to pdf. It all works fine on PC except for on a virtualbox and a laptop. When the user exports the report to pdf, it leaves some subreports blank! If the report is opened in the DB it pulls data as it should and all looks fine.
In the report, the missing data is from 4 subreports in the same top section of the report where a 5th subreport also resides. Subreport 5 is displayed OK. There is no dynamic formatting nor filtering in the reports.
These two machines had to have the 2007 Microsoft Office Add-in: Microsoft Save as PDF installed for the PDF export to work at all. Both machines are up-to-date on the latest windows updates. The virtual box runs XP while the laptop runs Windows 7.
This is the strangest error I have ever encountered as it only partially fails and it cannot be replicated on a regular PC.
I've designed an Access Database (using Access 2003) and assigned user-level security to it such that some users are read only and some are full access. Everyone requires a login and password to access the database. The problem is, once I copy/paste the database from my computer to the shared drive (where it will be accessed by all the users) the prompt for a username and password disappears.
View 3 Replies View RelatedWe're a small shop building a modest database to keep track of our product listings on eBay. Two people on non networked computers are doing the data entry into cloned copies of our database. This includes attached photos for each record. At the end of each week, we want to combine the records created separately into the master database on my system.
It seems like it would be simple enough to just cut and the paste the records from the two databases into the identical master. The problem I'm anticipating concerns the attached photos.
Some strategies are to transfer the records from the data entry computers to the master database while keeping the attached photos intact.
Is there an effective, efficient way to set this up or would it be best to use the OLE format for the pictures instead of attaching them (which I prefer)?
We are creating a database to log data on a project. There will be thousands of files. Can we input data, using the same table, at separate locations and then merge the data into a master table? We will need to do that many times.
View 1 Replies View RelatedHI, i have a field in a query called [cost_type], these typically contains the values "principle works" or "additional works" how can i set the query up so that it doesn't return the "works" part of the record? Could i just return the first 10 characters of the result?
thanks
Each record in my table has six possible sale dates as a result of cancellations. My problem results when a record is sold twice during the queried time frame (SaleDate1 and SaleDate2). Currently my query uses an if statement and if they are in the same time period, it will only return SaleDate1. I would like to see the record returned twice (once for SaleDate1 and once for SaleDate2). Any suggestions?
View 10 Replies View Related