Search results

Access 2010 Hi All, I am trying to export certain info from a query into Excel and have Excel open after export using VBA. Right now I use the "DoCmd.TransferSpreadsheet" command which lets me export the query and save it to an Excel file with a certain filename I have chosen. This works...

access 2010 Hi, I have a table with the following fields: - From - To - TypeOfWork (to be chosen from a combo-box) - Activity (text field to be filled in freely) In a table i have a complete day with times (from -> to), the type of work between those times and the activity performed between...

Access 2010 Hi all, I use the following code to open a splitform filtered by projectnumber and create a new record: DoCmd.OpenForm "ROVActivities3F", acNormal, "", "[ProjectNumber]=Forms!NewForms!LastProjectNumber", acFormEdit DoCmd.RunCommand acCmdRecordsGoToNew This all works fine when I...

Access 2010 Hi all, I have a report with some text boxes on it. Sometimes the text in these boxes can be a very long string of chracters (maybe a path to some folder). In this case I do not want the text box to grow. I just want the report to show me the right-hand side of this path and cut...

access 2010 Hi all, I have a table (POBListT) with 3 fields: ID (PK, autonumber), FullName, Position I have a form (POBDiveF) bound to another table (POBDiveT, 1 date field (DPRDate), 10 name fields (DiverName1-DiverName10) that selects people from this first table with a combo box. It shows...

Access 2010 Hi all, I have a form bound to a table which has 20 (name)fields and 1 date per record. A user fills in this form first to indicate which people are present this day. I know it would be better to use 1 name per record but that would in this case not work since the form must show...

Access 2010 For some reason I cannot scroll horizontally through the datasheet in splitform view, even though I have Scroll Bars set to "Both". Any thoughts?

Access 2010 Hi all, I have a bound form (splitform view) with the code "DoCmd.GoToRecord , , acLast" on the Form_Open event. When I open the form it does go to the last record and shows all the data that are in (some of the) fields. I cannot however manipulate the record until I click on the...

Access 2010 Hi all, I have a form with many buttons on it. Each button opens a different form. If the user finishes this From he/she can click the "Finished" button. This closes the form, goes back to the original form with all the buttons and turns the first button green...

Access 2010 Hi, How can I set the caption and backcolor (both predefined) of a certain button on a form by clicking a button on a different form? On the "fill-in" form I have a "finished" button. When I click this, I want the button on the main form that I use to get to the fill-in form to...

Access 2010 Hi all, I have a form with 6 fields (the table has 4): 1 date field (also 1 field in table) 3 combo-boxes (dropdown lists)(concatenate into 1 "activity" field in table) 2 text fields (2 fields in table) I would like the value selected in the first dropdown list to determine what...

I have one table (SafetyEvents) where users will register the amount of safety events per day. For each event, a reportnumber must be created that looks something like XXX-XXXXX-001. In my table SafetyIACT (a particular event), to register the reportnumbers I have the following fields: ReportID...

(Access 2010) Hi, I have a table with 22 fields: - 1 ID (autonumber) - 1 Date (date/time) - 10 x reportnumber (text) - 10 x description (text) I also have a form to populate this table. I would like an unbound textbox on the form to tell me the number of reportnumbers I have entered on the...

How can I add an ID-number that always increases (by 1) each time I add a new record to a table (using a form)? I want to always use some info from the record that was added last to fill in a different form. The reason for my question is that I heard that the autonumber does not necessarily...

Hi, I am trying to create a form with about 20 fields, with only 1 date field. Each time a user fills in the form, most values (but not all) are the same as the day before, so I have it duplicate on open. I would like the date value to be automatically adjusted, keeping all other fields...

How about this: I didn't have to go to work today because some snow fell earlier. It's result was the worst traffic in Holland ever!

Hi, My name is Mark and I am a new member from Amsterdam, Holland. I am relatively new to Access and am setting up a database for my friends company who makes reports on ships. This forum has been of great help to me already and I hope to keep learning from from al the smart people around here...