Search results

RuralGuy Thank you once again. I had edited the code to reflect what you had and it was still not working until I dug a little deeper. I have a combo called combo7 but in the combo's field view it says batch3. I can't remember how it got to be that way but it has been working ok so I will leave...

RuralGuy. Thanks for your suggestion. I just tried your method and achieved the same result as my effort above. I still can't enable or disable more than one field based on the text that is in MyField1. I need to enable/disable at least two new fields, MyField3 & MyField4 as well as the original...

I have been using the following in AfterUpdate event of "MyField1". This has worked ok enabling and disabling one field which in this case is named Myfield2. Now I want to enable and disable multiple fields based on text content of "MyField1" and am not sure what to do. MyField1 is a combo...

Go to your forms properties and look under the Data tab. Then set the Data Entry section to Yes. Next time you open your form it should be blank ready for you to add your new data. If you change your mind and want to see your data just change "Data Entry" back to NO. Hope that's what you want.

Have you changed the physical size of the combo?

Just go to Sample Databases in this forum and look for a post called "A Neat Little Calendar". It is really a simple and tidy calendar. If you don't like that I remember Old Soft Boss had a post somewhere which had an extremely simple but 100% reliable calendar which could be started by double...

[MyDateField] Between [Forms]![MyForm]![txtStartDate] And [Forms]![MyForm]![txtEndDate] Or [Forms]![MyForm]![txtStartDate] Is Null Above is what I use in queries which are used to generate my reports. I place this in the "Field" section (within the query) and then in the Criteria I put True...

Do you use two date fields, a start & end date, to view your data?

Cbarden I have used this method in the OnFormat/Detail section of some reports and it works well and is simple; If Me!YourField YourCodeThen Me! YourField.FontBold = True Else Me! YourField.FontBold = False End If End sub You can also use it to set visibility and color

MStef Thanks for your help. I have solved the problem. I did a small db redesign and came up with another plan of attack which works well and gives me access to valuable data. Unc..Giz.. Lol

MStef Thank you for your reply. I have looked at your posted example and the links are the same as those on my main form & subs. I have no problem with the main form + the original sub because these have been working 100% for years it's when I add the sub on the sub that I have problems.

I want to put a sub form on a sub form which lives on a main form. So far I've had a fiddle with the changes and have had trouble with relationships. For this type of sub on sub I'm guessing I have something to learn. Any suggestions?

Wakalo Thank you for your assistance. It is not quite what I was looking for however I can probably apply some of your ideas if I have a think about them, maybe. I really need to look at the field which contains the Batch Numbers and where I have two identical batch numbers then establish if...

You can use the Mouse Up & Mouse Down events (in your label/button) for a small movement of the button; In MouseUp Event put - Me! YourlabelName.SpecialEvent=1 In MouseDown Event put – Me! YourLabelName.SpecialEvent=2 I think the 1 & 2 are in the correct order, if not just reverse them. Do a...

I have a query which is based on a tbl which has data on chemicals in storage. The query is based on two tbls as follows; Main tbl ProducdID ChemicalName Second tbl Batch number TransactionID Transaction date Purchased check box Used check box, expirydate ProducdID When a chemical is...

Thanks for your reply PH. I remember reading some time ago that someone said that, to avoid bloat, make a copy of the db then edit the copy and import the changes back into the original db. Other than a safe guard against wrecking the original I can't see why that method would help much. If the...

I just added a small number of code lines to the OnFormat in Detail section of two Reports and seem to have increased the db size by 300-500 kb. It wasn't anything big or tricky just making bold & coloured fonts in three or four fields in each report. Included is one extra report & the extra...

PH Thank you for your speedy reply. Considering my poorly expressed question you have read it correctly.

Text v Numbers in Parameter Query? Is access better or otherwise at looking up data in numeric form as opposed to text in a parameter query?

vlad Have you checked your tbl relationships? When I have had similar results the relationships between tables has been the problem.