I hold information on a table about cartain jobs i.e. customerID, delivery date etc. Each job has a JobID. This table is called JOBS it is displayed on a form called JOBBOOK.
On this job form there is a subform containing all processes required for this job. This information is held in a...
I have a Menotr WL-R4RII wireless router. I have it connected to a Motorola Surfboard Cable modem.
My computer will pick up and connect to the router no problems and there is a strong signal.
I cannot receive any internet through it though can some ome talk me through sorting this out?
Hello,
I have found a record in one of the tables of my company's database that has somehow become corrupt.
When viewed using table view the record shows random characters and when viewed from the form its related to the field are filled with chinese characters and the autonumber field displays...
Hello all,
I'm trying to open a report that is dependent on an [enquiry_id] field as to which record is displayed.
The report opens from two different forms.
The query running the report selects the [enquiry_id] corresponding to that displayed in the form.
I am unable to find a way to run the...
It's a bit of a long way round and I'm not sure if it's particularly correct for your requirements but a simple fix would be to produce a form that pops up instead if you remove all the toolbars etc. it is much more easy to change is appearence.
Have you tried settign an event 'onlostfocus' so that the visibility of the box is hidden once it is entered.
For the onlostfocus event procedure try-
Forms![Form Name].[Text box name].Visible = False
I'm sure it's just one way to skin the proverbial cat, but hope it helps!
I am trying to develop a form that has a row source from two different queries or by having one query and the rest listed.
Can any one tell me how I would set up the row source to achieve this?
Hi I have the following code for a button in my database -
Application.FollowHyperlink "R:/File Cabinet/", , True
When I click the button I am presented with two warning that the page I am about to open may contain viruses.
I don't want these warnings to come up.
I have tried turning...
If it has been disucssed previously could you send me the thread for it please?
I've had a look round and I cna't find anything!
I can find plenty of problems for people with barcode readers but none for actually using the barcoede readers.
I've decided what I really need to be able to do is...
I work for a small maufacturing company.
We have 3 computers on our shop floor, these are used keeping track of jobs and stock using our company databases.
It is hoped that we will soon start to use Barcodes to track jobs and stock.
We have a barcode entry system up and running but atthe...
I have been working a company on a short term contract and I am about to finish. The comapny has asked me if before I leave will I clean out the company database and create some documenttion for future developers.
I have tried the documenter function but it doesn't really give me relationships...
I had a similar problem. An alternative you could try using would be -
Group by month(funding_date)
Since its solved its probably not important though.
I have done. I would like the text box to have 'dd/mm/yyyy' written in it when I move to it.
I would then like to to enter the date and have it appear instead of the 'dd/mm/yyyy' is it possible to do this?
Tried playing with the expression builder turns out I was using a wrong subform name and a different command line.
I ended up with-
[PurchaseMesh subform1].Form.Visible = True
Thanks
PHV
I have a form containing a subform. The for is called 'purchasedetailsB' and the subform 'meshpurchaseSF'.
I would like to make the subform visible or invisible depending on what a combo box displays.
I have set up an if function on the combo box, but when I run it I get and error message...
I would like to set up a form so that when a box is checked to finalise a form it copies the new record from one table into another as new record. How can I do this?
The tables don't currently have the same fields names and I could make it so they do, but is this really required?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.