Access Designer In The Wagga Area (NSW Australia)
Oct 20, 2005
Hi all
First off, I hope this post is not inappropriate for this forum!
I'm looking for a designer for access in the Wagga NSW Australia area to help me design a database for our small business.
Some of you may have seen some recent posts by me regarding an invoice database. I was attempting to do this on my own but I now admit defeat. I can't get my head around the basics let alone the difficult stuff so whilst I have made a few DB's myself in the past they were basic, this one is way too complax for my hard head.
I would love to hear from anyone in my area who could help with this on a one on one basis (Hence the need for being close to me)
I am willing to pay for this service & would appreciate if the person understands that I want as much input in the design as possible so I can understand it top to bottom when completed.
Obviously I would like some kind of idea how much this would cost me. Bearing in mind itis tutorial sessions as much as design I am looking for. I would dearly love to be able to do this myself via some TAFE trainning or the like but I simply don't have the time for courses etc as my schedule is very hectic.
Anyways, enough reasons, the gauntlet is down, anyone care to pick it up?
Regards Mik
PS - I would like to thank all those who tried to help this poor wretch but I'm afraid I am a monkey see monkey do kinda guy, much better with one on one.
View Replies
ADVERTISEMENT
Aug 2, 2006
I am looking to appoint a access designer to build and mange a parking management database. if your intrested drop me a line thanks
View 2 Replies
View Related
May 26, 2005
Hi, Big Jim here:
I am really not sure where to ask this one.....
My boss and I are in a jam. We have been using Access to run a reporting process, but one of our tables will exceed the maximum fields allotted this month. Our thought, dump the table into SQL Server and use the GUI interface provided in Access Projects.
Unfortunately, the query designer seems to have a few drawbacks. The one that effects us the most is in using UPDATE queries where more than one table is used to determine records to be updated. In attempting it, we get the message: "The designer does not graphically support the Optional FROM clause SQL construct".
Now I know we can manually create Update Queries, but we often need 1,000+ in a short period of time. Manually punching in all the fields involved and other code just isn't timely.
Question: Is there some alternative, service pack or anything else that would allow us to graphically create these Update Queries using Access Projects or even SQL Server 7.0? I would hate to have to scrap all the work we did over something that seems so minor.
Thanks in advance!
Big Jim
Set Up:
Windows XP
Office XP
SQL Server 7.0
View 4 Replies
View Related
Jun 13, 2012
I am getting the following error when connecting Crystal reports with MS Access.
---------------------------
Crystal Reports ActiveX Designer.
---------------------------
Logon failed.
Details: ADO Error Code: 0x
Source: Microsoft JET Database Engine
Description: Unspecified error
---------------------------
OK
---------------------------
I have select following options in crystal report -> select OLEDB (ADO) , database name as filename.mdb , db type as Access.
View 1 Replies
View Related
May 21, 2007
Sorry if this is inappropriate, but I don't think I've ever seen a post by a mod saying so.
We're working on a project developing an enterprise class solution for the petro-chemical industry. Currently we are building a prototype in Access and are in need of an Access developer to help with it.
If anyone in the Houston area is free and would like 2-4 weeks of work, please let me know. Our need is immediate, and would require that the individual work here at our office in Texas City.
Thanks,
Shep
View 1 Replies
View Related
Jul 11, 2005
I am a novice to Access so bear with me please. I've just created a form to populate some tables.
When I switch from design view to form view, the detail area in the form view is blank. :mad:
The header is fine but fields, which are present in design view are not present in form view.
Any suggestions, I've tried font/background colors and searching for a switch setting.
Thanks in advance,
JA
View 1 Replies
View Related
Dec 8, 2006
Is it possible, and if so, how, to change the colors of the background area where the navigation bar is?
(Area marked within included image)
View 2 Replies
View Related
Mar 12, 2004
How can I make my forms use the whole viewable screen area no matter what size monitor or resolution the end-user is using? I would also like all objects to be seen in the viewable area without the end-user having to scroll down or to the right. Is this able to be set in the form properties somewhere? I hope I am clear with what I am saying.
Thank You,
Chad
View 3 Replies
View Related
Feb 12, 2015
I need to make a random schedule every week. I have a new DB that I have attached and the current one being used that was built by some one else. The reason for building the new one is I could not figure out what to change to add a new section/Area for scheduleing.
What I have are 3 levels of auditors
Level 1 are the basic auditors which I will need 1 per shift per day
Level 2 Are operationl Auditors I will need 2 of the per week
Level 3 are management auditors and I need one of those per week.
When I get these compiled per week I will need to make a report to e-mail out.
I attached both DB's the old one to show what I need, and the new for a more stripped down and easier to update version.
View 14 Replies
View Related
May 4, 2006
I have a form (eg. frmMain) with a subform (eg. frmSub).
The subform is going to be a query which displays results based on criteria defined in the main form.
So say frmMain had a field called 'OrderDate'. When they typed an order date, all the orders on that date appear in the subform.
The way I have it set up at the moment is that the query criteria is like [forms]![frmMain]![orderdate]
Do this means that once the order date is entered - there is still no results in the subform because the query has already run when the form was opened and, as this field was then blank, no results were returned.
I would like to keep this setup, but - instead of having the subform set to the query, it would be set to another form which just has a commond button.
The user will then input the OrderDate - click the button (which is in the subform) and the query will run. This can be done easily. HOWEVER, is there a way for the query results to be displayed in that subform area after the button has been clicked instead of opening up a new form.
I know in web design you can target links to frames, so wondered if this was possible?
View 1 Replies
View Related
Oct 16, 2006
Hi..
I am using RTF2 ActiveX Control which enables me to include the Rict Text Controls in my Access Form.
I want to generate a doc document out of the information which i type in the RTF2 Area on the Access Form. And whatever Rich Text Format information i have written there (for eg in Bold, Italics, Indentation, Tables created, Bullets n Numbering etc), is retained as it is on the Doc document which i am generating with the help of bookmarks.
Please help in how do i do that 'coz i am not able to do it using the Rich Text Format...
Thanking you,
with regards,
Kapil Sharma
View 3 Replies
View Related
Jan 17, 2013
I'm using access 2010 and have Tabbed Documents enabled as well as Display Document tabs.
When i open a form in design mode, it appears that I have the option of setting the form size parameters by dragging the page boarder horizontally or vertically to grow or shrink the size of the form. When I change view back into form view however, these changes don't appear to be having any effect on the form itself.
My question has two parts:
What am I actually affecting when I adjust the page size in design mode?
Is it possible to set a definitive end to a form in form view without reverting back to the Overlapping Windows setting?
View 3 Replies
View Related
Mar 19, 2014
I have show results of scores on a graph but need to show if those scores fall below, in between or above acceptable limits. For example, lets say the acceptable range is between 10.5 and 15.6 but people can scores between 0 and 50. So what I need to do on a report chart/graph is show the actual scores in columns, let access automatically adjust the scale, but have the area between 10.5 and 15.6 on the scale highlighted or coloured or perhaps indicated by two horizontal lines across the chart/graph.
View 5 Replies
View Related
Mar 14, 2013
I have a button placed on a form, but it is only clickable a few pixels along the bottom of the button. If you hover anywhere above this, the button is not clickable and does not highlight as if it is clickable.
I have deleted the offended button and recreated it, but the same strange behavior occurs?
If I move the button up a few pixels or more, then the clickable area shifts to the top of the button and the bottom becomes unclickable.
The buttons are in the header of the form and is completely visible when the form is in normal form view. I also can not see anything that could be sitting ontop of the button (no transparent controls or anything) that could be obscuring it.
View 1 Replies
View Related
Sep 26, 2011
Is there some way to do this:
SELECT (sum(d.cartonsshipped)/m.ctnperskid) AS PalletCount, itemnumber, shipdate
FROM orderdata d
inner join itemmaster m
on d.itemnumber = m.itemnumber
GROUP BY d.itemnumber, d.shipdate
HAVING (sum(d.cartonsshipped)/m.ctnperskid) > 0
ORDER BY d.shipdate, d.itemnumber;
and not get the aggregate error (3122). I am guessing it's giving me the error because i try to do a function in the select area.
View 2 Replies
View Related
Dec 6, 2013
How do I move combo box label into the form header area while leaving the actual field title in the detail area in a subform so they looked stacked like the other items??
View 1 Replies
View Related
Oct 27, 2013
What I am trying to do is i have a list of area codes connected to other data
What I want to do is do a search on a telephone number and this will check against the area codes and diaplay the required info
Example
Area info1 info2
01234 ab cd
012345 ar mc
01235 fg tr
So if I put a number like 01234567890 in the search box the result it will show is 012345 ar mc as this si the closet match to the telephone number.
I did it in excel with
=INDEX(whatwouldbedisplayed,MATCH(searchinfo,rowof data,1))
Im not to sure if this can be done as a query so would it have to be a macro?
View 2 Replies
View Related
Jul 2, 2013
I just copied a form from one database to another and for some reason the copied form in the new database does not display. the form opens but the area with all the info is blank... When I choosed design mode it all shows up correctly but in form mode it is just blank.
View 3 Replies
View Related
Mar 28, 2013
I have a combo box in the header area. The record source, Bound Column are set correctly ( I know because I tested it on a form ). In this instance, the user would select from the dropdown list, the name of a member of staff, based on the click-event, and passing the Staff_ID to a variable, this would be used to filter a recordset/recordsource for the report. However, there is no dropdown ( or arrow on combo - so no name can be selected ) ?
View 2 Replies
View Related
Oct 10, 2013
I have a table that shows "DONE" and "REMAIN" for each "AREA" like below:
Code:
AREADONEREMAIN TOTAL
AREA1100200300
AREA2200300500
AREA3200700900
Now I like to make a report that shows "DONE" and "REMAIN" in each AREA with pie chart, now I have problem how I have to do this job for the graph, how should be "row source" of chart control. What query needs on this table?
View 1 Replies
View Related
Oct 15, 2014
What would be the best table construction to allow for the inclusion of area information that varies depending on the selection of a certain route, to also include crossovers?
For example, if I had the following
R1 - AreaA, AreaC, AreaF AreaK
R2 - AreaC, AreaF, AreaL, AreaN
R3 - AreaC, AreaM, AreaN, AreaQ
How best to allow users to see all of the areas that apply to each of the routings, but not to be presented with the same grouping twice if more than one routing is selected at the same time?
I should add that I am looking to have these selectable by a combo that is filtered according to the value(s) in other fields.
View 5 Replies
View Related
Sep 16, 2013
I have a query to count the number of society members in a particular UK Postcode area. It works well for a single Postcode reference but adding further references to the Query Design View generates an 'or' or 'and' statement, rather than the additional counts that I need.
The SQL code I use for a single reference is :
SELECT Count([Mail List].[PostCode]) AS CountofPostCodeH
FROM [Mail List]
WHERE ((([Mail List].PostCode) Like "BN5 ???"));
How do I amend this code to produce counts for multiple references in one query.
View 9 Replies
View Related
Jun 26, 2015
I have got a query which gives me the following output;
Nr ----------- area ------- area 2 ---------- holler
14-1096-------1------------1-----------------5.9
14-1097-------2------------2-----------------7.8
14-1100-------1------------1-----------------13.4
14-1101-------2------------2-----------------7.8
What i would like to do is to calculate the sum of holler when they are in the same area.So the sum of nr 14-1096 + 14-1100 and 14-1097 + 14-1101. Ive tried to do the following;I tried to do the following just to check it would even work;
Code:
test: (SELECT Sum([holler]) FROM querytoetsn2hr_gemiddelde_filter WHERE ((querytoetsn2hr_gemiddelde_filter.area)=("1")))
Which worked perfectly, it gave me 19.3..
Code:
test: (SELECT Sum([holler]) FROM querytoetsn2hr_gemiddelde_filter WHERE ((querytoetsn2hr_gemiddelde_filter.area)=(querytoetsn2hr_gemiddelde_filter.area2)))
That gave me the sum of all 4 the Nrs. Which makes sense, because you basically say that as long as area and area are the same calculate the sum of holler.if there is a way to say "sum of holler when area has the same value".
View 2 Replies
View Related
Jan 29, 2007
Hello,
I have installed Microsoft Access 2003 and Microsoft Access 2003 Developer Extensions. I can create Access application by using the Package Wizard.
But after I upgrade from Microsoft Access 2003 to Microsoft Access 2007.
I can't use the Package Wizard.
How can I do to solve this?
Thanks.
View 1 Replies
View Related
Jul 10, 2006
Hi,
I have been using "fSetAccessWindow (SW_HIDDEN)" in the open event of my
main switchboard to hide the grey Access screen from being visible behind
forms, reports, etc in this db. But when I started using a .vbs script file
to launch the db, the Access window stopped being hidden. (The reason I use
the script for launching is that it temporarily sets the db's security level
to 1 which stops the macro security warning from coming up.) Apparently MS
knows about this happening and released a technique to rectify the situation,
but I don't understand their instructions. It looks like they expect one to
have more understanding than I have. Could someone help me get this
impliemented? Here is the article:
http://support.microsoft.com/kb/167659/en-us
Thanks!
View 2 Replies
View Related
