Search results

This worked for me: Basically it's an access 2010 bug: One way around the bug: If you open the list, move the columns into the correct order, right click a column heading and click unhide fields, then click close and save the form it should keep the order. Just the normal way of moving columns...

Found it... The column order follows the tab order on the form...

The problem was in freezing the columns. I did this to maintain a custom order for the columns...

Thanks! It was the unfreeze... The reason I froze it, was to keep a certain order of columns. Do you know how to keep the column order after re-ordering?

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?

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

Where can I find this "Open Form in Edit Mode" option?

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...

And what would I do if I wanted a second Where clause?

There will actually be only one user who fills in the forms (1 per day) per project of 6 weeks. Each day this user will go through all the forms (buttons) and start over the next day. I see your solution and agree that it would have been better that way. If however I could only just save 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...

Like this?

Hi Michael, The reportnumbers I talk about have nothing to do with reports in or created by Access. In case of a safety event our data admin needs to write a report about this, which has to have a number corresponding with the date, projectnumber and how many reports have been already made for...

Thanks. I still don't know how to count the number of reportnumbers in the current project or the current DPRDate and how to create the appropriate string for each new reportnumber...

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...

It gives me a "0" value in the unbound textbox. 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...

Okay I changed the structure. The "DCount: code however does not work...

Hello Paul, Would I still be able to have 10 fields for reportnumbers and 10 for the accompanying description on a single form this way? I understand the advantage of normalization but I would rather not change the entire stucture anymore... I found the following code that should do what would...