Search results

I have a really simple problem regarding a calculated field on a report. It is: I have a 2 fields on a form that show the a number of days each. These fields are works_impact and procurement_impact. I want to make theses fields invisible and place a text box simply to add the two figures...

Does any one know if it is possible to change the icon of an access batabase. I have selected an icon within the startup menu and this changes the icon to the top left hand cornere when i am within the program. What i want to change is the icon that appears on the users desktop.

I have a report that lists instructions received together with the days it will take to carry out the work. I need to create a calculated field that simply shows the greatest or highest number of days on the report. Is this possible?

I am trying to do a nvery simple if, then statement but it doesn't seem to be working as it should. I know the solution must be really simple. Anyone shine some light. Private Sub Form_AfterUpdate() If text69 = "" Then MsgBox ("no impact") Else 'DoCmd.OpenForm "notice_input_form", acNormal End...

I have a multiplke selection list box that passes its value over to a text box. When this is done the user go onto the next record but the list box doesn't reflect what items have been passes to the text box. How do i refresh the selected items in the list box or better still have it show the...

I have a list box on a form which looks up the records from a customer names table. When the user selects the customers to be associated whith the current record of the form i need this information to be written in the 'associated customers' column of the form table. Hope someone can point me in...

Hope you can help. I want to create a macro to install templates into microsoft office. I need to establish firstly what operating system the user has and then what version of office. This will the dictate where the template files will be stored on the users hard drive. Any suggestions as to the...

I have a linked table called (COR_log) This is for incoming orders. I have a main table which holds the data for outgoing orders. Each outgoing order is funded by particular incoming so when entering thje data for an outgoing order i can choose which incoming instruction i want. I need to...

I want to create a query with a parameter that prompts the user to enter a word or words. This will the return all the records from the table that contain that word or words. I have entered the following: Like [ Enter word to search for] & "*" Is this possible or not?

I have a database that the startup options have been set to limited menus. I need to open the database and alter these settings. Is there anyway this can be done?

This is strange anyone help? I have a unsecured database that can be opened by another user normally. If i attempt to open it from my machine it asks me for a log on password. i am pretty sure i havn't set myself up a password can anyone point me in the right direction?

Anyone help? I was happily building my database and then suddenly its saying i have not got exclusive rights and may not be able to save changes. Anyone help?? Thanks

I think im missing something really simple here. My problem is i have a query that produces one figure. I have base this query on the data i select in a combo box on my main form. That all works ok. What i want to do is simply transfer that result to a text box which is also on my form. Any help...

Hope someone can point me in the right direction. I have linked an ecxel worksheet 'called COR log table' within this table is a list of documents each with a value attached. For example one may have a value of £100,00.00. Within the access database there are orders raised against the ' COR...

This is probably so easy but i just can't see the solution. I have a form with several fields one being an autonumber field. I have got a button that when pressed opens up a report.When this happens all records appear. How can i get it to just print preview or print the current record i am on...

Not sure if i can do this but here goes. I have a form where i enter details of a transaction. There is often a word document refered to within a text box field on the form. I want a button that once pressed opens that document. Any ideas?

I want a text field to become invisible when a combo box has a null value selected. I have set the text box visible fiels to 'No' and placed this small peice of code in the 'Form_Current' section. If Combo10 = null then Txtname.visible = true else Txt.visible = false End if End sub But this...

The code below brings up a "Do you want to save message box" problem is for some reason it saves even if you press No. Can anybody spot the problem? Private Sub Form_BeforeUpdate(Cancel As Integer) Dim Msg, Style, Response, MyString Beep Msg = "Do you wish to save this record?" Style = vbYesNo...

I think im missing something obvious here goes. I have a table called 'names' within that table there is a field called 'Company' and a field called 'lineone'. On a form i have got a combo box that looks up the company field in the names table. I want a text box to populate the matching...

Can anyone help me with this. Im sure im missing something really simple. I have 6 text boxes in a table. In each text box there can be one of a possible 5 leters ie. "AI" or "A" or "NR". i need to make a query to count how many "A"s are in my database and how many "AI"s etc. I have tried...