Search results for query: *

I am very green with access and really only using macros at present. I am wanting to cycle through all of my records in form view. I have been able to do this with a simple GotoRecord Next on a timer. The problem is when it cycles through all records I get an error because it is at the end of...

When I export using the outputto function in my macro it works fine until I click the "show database window" in the startup screen. I don't want the screen to show in my database but when it is not shown I get an error and the macro can not be run. If I show the database window everything works...

My field is set as text as depending on the entry a number or a letter may be entered. I would like to run a query that adds the numbers together for a particular field. Thanks for your help...

My memo field in a query is being truncated to only display 255 characters. When this query is used in my report the same thing happens. The field is set to memo in the table. Can anyone help please? Wayne

I am wanting to delete a table in my database if it exists. I am able to delete the table if it is present but errors if it is not present. My code so far is Public Function DelTables() strFile = "ASCCopyT"**********I need code here that identifies the table*************** If...

I have a form called "ParentF" with a datasheet subform called "ChildSubF". "ChildSubF" has all allow edit,filters, deletes etc set to "yes". My "ParentF" has allow edit set to "No". On opening, both parent and child forms aren't editable which is the way I want it. I have created a button and...

I am trying to have a field on a form that has a default value of the username of the person who is entering the data. My database requires a user to log on. I have a form with a field that I want to default to the users name. Can anyone help please.

I have a make table query that has only 2 fields. Unfortunately the fields are both autonumber fields from seperate tables. I am unable to run the query as I will be creating a table with 2 autonumber fields. These fields do not have to be autonumber fields in the new table. Can anyone help...

I have a simple form with a wizard created delete button. In the past when I clicked the delete button it would prompt prior to deleting. Now the record is deleted and can't be retrieved if clicked by mistake. I have checked the options and made sure prompt is checked in there. Is there...

I would like to have 27 buttons on a form. (26 letters of the alphabet and one that selects all letters) I can do this with an option group. I need to relate the allocted number from the option box to the query that the list of records is based. How do I do that. Do I have to use code? (Which I...

A have a form that isn't based on a query. Purely cosmetic. Within this form I have a form that is a list of clients and their details. (A bit like a datasheet) The list is now very long. I have a combo box on the main form. When I select a client from the list I would like to be able to jump to...

I have an ActiveX Calendar on a form with a control source on the same form. If I change the date by clicking the calendar the only way I can have the calendar adjust the control to reflect its value is to click into the control. I want to be able to have the control change when the calendar is...

My form consists of 1 chart. The form its self is not bound to a table or query. The chart however uses information from a query. If I filter the query by putting a filter in the grid as normal everything works fine. If I add an [Enter Name] to the grid or a reference to a form...

My report consists of 1 chart. The report its self is not bound to a table or query. The chart however uses information from a query. If I filter the query by putting a filter in the grid as normal everything works fine. If I add an [Enter Name] to the grid or a reference to a form...

I have an OLE object field on a form. Everytime I insert a picture into this field it appears as an icon. I have my properties set to content. It is driving me crazy. Can anyone help. Wayne

I am trying to open a web site without the user having to click on the link. Is this possible? My intention is to run a macro that makes a couple of tables via "make table queries" then open into a website. The user is only to press the button once to run all of this? Thanks in...

How do I make a control disappear in code. My Calendar is located at [Forms]![GreetingF]![DateF]![ActiveXCtl1] I have been able to make it work using the setvalue command in a macro but I would like to be able to do it in code. Thanks in anticipation Wayne

I have a nested subform. A popup form is opened and information from this using the "setvalue" command is copied from the popup to the subform. My intention is to be able to copy as many parts of records from the popup to the subform as the user required. (It works like a list of items...

I have a nested sub form (Continuous Form). In the footer of the form I have a simple calculation that adds all of the costs that are listed in the detail section of the form. Everything works Ok. I want to add a button in the footer called that when clicked requeries the form to enable the...

I am able to change the formatting property of a field by choosing fixed then 0 in the property box. The problem arises when I have a label that refers to a field. eg [Number]&" % of people are in attendance" How do I force the [Number] to 0 decimal places? Wayne...