Search results

Sorry brenkenathan, I am at a loss for a solution for you. At our University we use upwards of 2,500 suppliers but the data for the invoices is held in one table. If the differences aren't too great, I would still consider the one-table option. Perhaps by modifying the fieldnames in some of...

You're right Jim, Your method is a good, quick and simple solution and anything that gets us way from those naff grey buttons must be for the better. It's a shame that MS don't include a library of button shapes and objects that can have similar properties to buttons etc... Although I do...

No, sorry. It's not clear to me at all. Can you show me what a typical Code field contents would look like in the table, then perhaps I can grasp the concept. It's only me being thick, I'm sure. Dave E

Am I right in thinking that you have 13 different tables, one for each vendor's invoices? If so, you might have given yourself a problem. You could have put all the vendor's invoices into one table and added a field to identify which vendor and one to identify which site. That way your query...

I've done this using the method described by indecisiv and it worked OK. I had a date/time field on the form called CallTime and it's ControlSource was =Time(), it's Format was set to LongTime. Using the ONTimer (set to 1000 - 1sec intervals) I triggered the event which was -...

Join the fields together for the report by using a bit of code - Depending on the datatype of the fields - If they are string fields - Result=[Field1] & "," & [Field2] where Result is an unbound field on the report. the 2 fields.visible=False, so you only see the combined Result. If...

Try - DoCmd.Requery("ObjectName") on the AFTERUPDATE property on the preceeding action. HTH Dave E

It depends on the version of Access you are using. '97 has no feature that will do this but there are 'get arounds'. Search this topic on ther forum, I downloaded a good example a few weeks back. If it's Access 2000, there is a feature called conditional formatting that I believe can used...

Jim, If you make the button trnsparent, doesn't that rather defeat the action of the button? You wouldn't see the movement. If no action is required, then wouldn't you use the OnClick property of the box? Dave E

For data input it is prudent to check on the quality of the data before it gets saved to tables. I have often used unbound fields on the input form to gather the information, do the checks, and then save the record to the table(s). This way, you are in complete control of table records. The...

Depending on the number of zones required, you could create a checkbox for each zone. That way, the user can select any permutation of zones. It will need some code record the selection for the tables. Dave E

I would try using DLookUp in both combos in the following way - In the AFTERUPDATE property of the combo (Item#) use this code - If IsNull(Prod#) Then DLookUp("[Prod#]","[Products]","[Item#]=Forms!MainForm!SubForm.Form.Item#") End If In the AFTERUPDATE property of the combo (Item#) use...

I think you have left a reference to the macro somewhere where there shouldn't be one. The code I refered to should go in the AFTERUPDATE property by clicking in the property, then on the 3 dots (...) that appear on the righthand end of the line and select Code Builder. When the Code Builder...

Basic coloured buttons. No frills but better than the old grey ones supplied by MS Access. (See attachment for examples and documentation) Dave Eyley

I did this recently on a Helpdesk database. What I did was this - On the current form, with the datasheet list or continuous form, get into the design of the subform or the wherever the list fields are displayed. In the leftmost field open the OnClick property of the field and use the...

I love problems! And solutions are ecstasy! Good Luck.... Dave Eyley

Well I'm a silly billy, aren't I? If you ignore most of what I said before and put the code in the AFTERUPDATE of TEXTBOX1 so that it reads - Textbox2=Right$(Textbox1,Len(textbox1)-1) then Textbox2 can have its controlsource from the table. I apologise for any confusion. The only problem...

Hi Jennifer, There must be lots of ways of doing this... Using 2 List boxes - 1st List box has query linked to table with course names. 2nd List Box has query linked to table with members. Button ('Select') adjacent to ListBox 2 to make choice. In ONCLICK property of Button - Dim MyDb As...

I think Rich's solution works, but until the ToBeCompleted Field is updated, it will show as #ERROR. Dave E

I've had this one too... For me the reason was that the form was trying to carry out an action on table data on the ONOPEN property, but because there was no data in the table, I got this message. If there is no data in your table underlying the form, put a dummy record in to start it off. You...