I have a orders sub form that was working great .Then all of asudden when i when to input information into the fields i realised the grid under variuos field names has disappered (Icant enter any info),surly this must be something i have accidentally done without realizing.
View RepliesI am writing a database to track our (and others) wine collections. i'm wanting to track what bottle is where. so i can look up what i have, look up where i have put it and away i go to get it, simple right?
just to complicate things i want a system in place. where the end user and use forms to add/remove or modify wine racks.
assuming that all racks are rectangular i would like to be able to add a rack and call it rack 1. rack 1 has 4 shelves all able to hold 5 bottles. the database would then say that bottle X is in rack 1 shelf 1 position 1.
if possible there will aslo be a screen that is auto generated by the database showing a simple grid with grrn and red squares denoting if the position if full or empty. the ability to click on a position to see what is in there or to add a bottle there would be amasing but not fussed if that can't be done.
I am struggling with a slight form delay. When it opens on the OnOpen event, i am populating a grid. This takes about 3 to 5 seconds but, the it also takes the form the same time to open. What i need to do is get the form to open then populate the grid. Can i make the form open first then populate?
View 4 Replies View RelatedHere is a project. I have a grid on a form. its width is 20cm wide and 15cm tall. in the grid are 6 groups of columns (all columns listed are from left to right).
Group 1 - 5cm wide - description
Group 2 to 6 are 30cm wide and represent days. Each group is split into 8 columns which represent hours per working day.
I need to to draw or position a line over the grid depending on what day it is and time. for example, lets say its thursday at 14.30. ( the 8 hour columns run from 8am to 4pm ) it would need to look like this-
So I need to work out the position of of the line depending on the time of of the day in the week. The day can be determined by the column header, the time by the grid....
Up until recently, when I selected multiple objects in design view (on a form) and right-clicked the mouse, I had several options in the 'Size' sub-menu (including 'Size to Widest / Tallest / Narrowest / Shortest').
Then I tried to be clever(!) and create a new custom toolbar which had just these options on it, as I use them frequently. This was all very well until now, when I can't find the custom toolbar I created, and the options have disappeared from the Size submenu aswell!
Has anyone got any ideas on how I can get them back??
(I have tried going into Customize to drag them back, but they're not there either! :( )
:confused:
Hi,
My mainform, which controls virtually all operations, has dissappeared.
Since it´s supposed to load when starting the database, the form actually loads, but you can´t see it in the forms window.
when I try to edit the code I get the message "module not found".
What do I do?
Thanks
Fuga.
Hi!
I'm currently facing a strange problem! When I want to insert a command-button, a drop-down menu etc. no userguides appear anymore. I like to do the most basic work in design-mode, so I kind of miss then a lot...
How can I make them come back???
JR
Hi!
I'm currently facing a strange problem! When I want to insert a command-button, a drop-down menu etc. no userguides appear anymore. I like to do the most basic work in design-mode, so I kind of miss then a lot...
How can I make them come back???
JR
Hi there
I've been playing around with creating a switchboard. At first, I saw a form appear in the forms area called switchboard. but now it's gone. I have a switchboard marked as Default under Switchboard Manager, I can see that a table has been created called Switchboard Items, but it won't open on startup. (obviously, because there isn't a form which I can point to in the startup box)
Any idea why the switchboard form is not being created?
Thanks
Sunil
Views show design view, datasheet view, pivot table view, and pivot chart view. Where did layout view go, and how do I replace it?
View 3 Replies View RelatedCan anyone help with this ANNOYING problem?!
The Database Window within Access on my computer seems to have kinda half disappeared under all the toobars at the top of the screen. Each time i open it it seems to have moved further up. The problem is, that because it is underneath the toolbars, I can't click on the window of it to drag it back down! Now, its got so far up that i can't even select any of my tables, forms, queries or reports because i can't see them!
Its SOOO annoying! and i have no idea what to do about it!
Help please.....:confused:
Hope someone can shed some light on this.
I have imported the contents of my database into a new database, as all the testing is completed and want a clean start without any dummy data in it or anything. My main form which is where most of the interaction with the database goes on appears blank with no controls on it on form view. In design view, I can see everything (buttons, search fields, subforms etc) but turn into form view, it's blank (except the header). Does anyone know why this happened?
i am using MS Access 2010, i am on initial stage and i have to made main log in form or switch board, but as soon i create a blank form and click on button in design but only command button appeared but not along with command buttong wizards so i will select button to close application or to open a farm and so
View 1 Replies View RelatedI would like to seek guidance again on my new project, I wanted to create a data entry form that the user can input records using my unbound label boxes, then upon hitting an add button it will go automatically on a subform below or a GRID so that the user can see all the records at a glance.
View 2 Replies View RelatedGood morning All.
I have a database which updates via a Function in a module every morning (i.e imports and exports data).
Yesterday the DB crashed and incurred a problem. The DB was closed down and re-opened.
When it was re-opened all the Tables, Queries, Forms, Reports and Modules were no longer showing in the DB window.
When I selected the Tables tab the following message appeared:
Operation Invalid Without Current Index
this was then followed by another message:
"Isn't an index in this table. Look in the indexes collection of the TableDef object to determine the valid index names
This also appears if I try selecting the other tabs i.e. Queries, Modules etc.
The strange thing is the DB still updates at its stipulated time, and still imports and exports data. I am running Access 97.
Does anybody have any idea of how I can sort this out?
Regards
Chathag :confused:
I have a form with a query assigned to it . it has also some controls to filter the data when i filter the data and there are any relevantr data for the results the form shows nothing for the query and it's true but the controls will be disappeared and i have to go out from the form and come in again to be able to filter the query again.
View 3 Replies View RelatedI am around 2 months working with access. I created an application/dataentry form and it was working very well. suddenly today, I got an error which says. Run-time Error 5 "Invalid Procedure Call or Argument. together with that or may be independent, a pop up search form just disappeared. I put a msgbox in form load of pop up form and the msgbox appears but the pop up form just disappeared.
I was about to give the application to use and thats when all these happened ...
I have Grid X and Grid Y set at 24. Usually I see dots all over my forms.... which allows me to snap controls to the grid. Today I only see large boxes instead?
Did I change some setting?
Thanks
I am a beginner with aggregate functions.
I have two tables, one describing parts, and one describing assemblies that use those parts:
tblParts show all the part descriptions, including fldPartNumber.
tlbWhereUsed shows zero or more fldAssemblyNumber records for each fldPartNumber.
I want a query that shows, for each record of tblParts, the number of assemblies that use that part. I specifically want to do this with an aggregate function:
DCount("*","tlbWhereUsed ","[tlbWhereUsed].[fldPartNumber]=[tblParts].[fldPartNumber]")
but I don't know where to put this function call in the query grid.
(I do not want to do this in VBA, if I don't need to).
Thanks in advance...
Hi all,
Can I add a flex grid control on a MS ACCESS form.
IF yes, does MS access 2003 has a flex grid control, i cant find one in the toolbox.
MAy I know where can i find the control?
Thanks
trying to add 2 fields
=[field1] + [field2]
works but I want a space between the 2
how do you do that?
jon
Hi everyone;
I am using Access 2003 with Windows XP Pro. I have a problem with using a query and the dreaded UK Postcodes!
I have a Client table that contains a field “Client Postcode 1”, in which is entered the first part of the UK postcode i.e. AB11, WC1A, E1, EC2V, etc.
In a Candidate table here are many text fields where we enter which postcode a Candidate wants to work in, i.e. TN, CV4, EC, W, etc.
We have a separate Candidate Search form where we select a particular client (Combo box from the Client table) which then displays the Client’s Postcode 1 data i.e. the first part of the UK postcode before the space.
We have a select query that then tries to match the Client Postcode 1 with the postcode that the Candidate wants to work in from the Candidate’s table.
In this query design grid I have successfully created criteria that will match the Client Postcode 1 field to the Candidate’s postcode field – very straightforward. This, for example, will match a Client with a TN39 postcode with a Candidate who wants to work in the TN39 postcode.
In the same query design grid I have also been able to successfully match the Client Postcode 1 field to a Candidate’s Postcode field using just the first 2 letters (using Left). This matches a Candidate who wants to work anywhere in the TN postcode area (TN1, TN2 etc.) with a Client whose postcode starts with TN
However, what is stumping me is where a Client’s Post code has only 1 letter followed by numbers (E1, B2 etc) in the first part of their postcode without returning EX, BL etc. I would like the accumulated wisdom on this forum to point me in the right direction to design criteria to input into the query design grid that will match ONLY the first letter of the postcode IF the second character is a number.
Regards to all - and what an excellent site!
I have the following field which is stored as a string: [field3]"2006090111123500"
the first 8 characters represent the date but backwards.
I want to filter between dates.
I have the following in the query grid:
CallDate: DateValue(Right(Left([Field3],8),2) & "/" & Mid(Left([Field3],8),5,2) & "/" & Left([Field3],4))
with criteria: >=#01/10/2006# And <=#31/10/2006#
This seems to work on october data no problem
I had hoped to put all the september data into the same data table and filter but it failed so I created a new table called september data and pointed the query to it but for september:
with criteria: >=#01/09/2006# And <=#30/09/2006#
however the query fails if I take out the calldate expression it works no problem.
In fact it works providing I dont try and filter on date or sort by ascending.
it says data type mismatch in criteria expression. I had hoped that datevalue would turn the string into a date.
Its strange that it works in one query and not in the other with only the data being different.
Can anyone see why this should fail have I done something stupid?
kind regards in advance.
peter
Hi,
In my first steps working with Access I feel unable to find out how can I create a report that shows the data (records from a Clients Table - Name, Phone, e-mail fields-) in a "spreadsheet like" format with gridlines. Can anyone help me on this?
Thanks
I have a query that runs to check if a form has any empty delay hrs.
Code:
SELECT [Tble-wcDelays].ID1, [Tble-wcDelays].LinkingID, [Tble-wcDelays].HoursDelay, [Tble-wcDelays].ReasonDelay
FROM [Tble-wcDelays]
GROUP BY [Tble-wcDelays].ID1, [Tble-wcDelays].LinkingID, [Tble-wcDelays].HoursDelay, [Tble-wcDelays].ReasonDelay
HAVING ((([Tble-wcDelays].LinkingID)=[Forms]![Frm-RPC]![wetcleanID]) AND (([Tble-wcDelays].HoursDelay) Is Null)) OR ((([Tble-wcDelays].LinkingID)=[Forms]![Frm-RPG]![wetcleanID]) AND (([Tble-wcDelays].HoursDelay) Is Null));
I'm trying to avoid cerating multiple queries that dothe same thing. But if this qurey runs from the form "FRM-RPG" then It errors because it can't find "FRM-RPC" so why does it not over look that frm and go to the 2nd Frm ?
Hey.
How do I format Date field in query grid to make field into "11/11/2007" if the data originally has time, or in form "11 Nov, 2007" ?