Search results

This is how the end user has requested it so who am I to say otherwise. I gave them the option of how it could look and because their users are used to spreadsheets this is how they requested it.

thanks for this. It all looks very complicated for a novice like me but I will try to figure out how it works to see if I can incorporate it into my application. It might be difficult as I have my two forms as sub forms on a Navigation subform which arent the easiest things to code.

I have two datasheets on a tabbed navigation form which I would like to synchronise horizontal scrolling. Not sure where to start or how to go about this or if its even possible. Each form is bound to separate tables with 18 columns (RA, RB up to RR, one for each type of Box) that contain...

Right I have found a solution. Set the table properties as Currency but declare the variable as a string but also format it as "0.00". Thanks to everyone for their input, we got there in the end. Dim strCarriageCost As String strCarriageCost =...

I have tried Currency both setting the table properties and declaring the variable as Currently and although it appears to store the value in the table OK it still only returns the variable without the trailing zero. this is driving me nuts as it should be simply really.

I have a csv file that I import into a table which contains costs of delivery. I import this table into my application on a regular basis as and when there is a cost change. The table stores the values as Double and is formated as #.## to 2 decimal places. This shows a value for example as 2.20...

Unfortunately it hasn't worked. I tried the below and although I dont get any errors it does nothing to the Datasheet subform. [Forms]![frmMain]![NavigationSubform].[Form].[Controls]![DS].SourceObject = "" [Forms]![frmMain]![NavigationSubform].[Form].[Controls]![DS].SourceObject =...

thanks but I still would need to know how to reference the datasheet subform from the DS subform in order to remove the source object from it and then put it back again. Or do you mean from the DS subform?

I dont think I am going to be able to requery the Datasheet subform unless I know how to reference it which is what the my original problem was. When I click on the tab at the top that reloads the whole form but there is no code behind the tab so I dont know how to code it to reload the whole...

Ive invested too much time into the whole application to ditch it all now and dont really have the time to redesign it all. I am up against it tbh and need to get this working ASAP.:banghead: Going to come back to it after I have been for a run

How do I get the datasheet subform to reload within the DS subform? I have code that hides and unhides columns but I cant get the changes to take affect unless I reload the whole form. I have tried to .requery but this has no affect on the Datasheet. I have to click on the tab of the...

Thanks Minty It will take me a while to strip it down but I will try if I cant get the dam thing to work. I may end up putting the code on the actual sub form and then just have a button that on the DS form that requerys the subform. The buttons only hide and unhide columns depending on the...

Thanks but it doesnt help with my senario unfortunately. I am on the tab with the subform that I am trying to reference. I can reference a control directly on the DS subform. But I have a further subform(a datasheet) that is within the DS subform and this is where I am trying to reference a...

I had made a mistake where the form was located. It was on a subform that was on another subform inside the the DS subform so an extra layer. So this is what is was Main Navigation DS sfrm_DS_ConvDetailSub frm_DS_ConvDetail I was trying to reference a control on there However I have now moved...

Ive tried using the expression builder but once I get to the [DS] part of the syntax nothing comes up which references my subform. I have the form loaded at the tab I am trying to reference so its not that but thank you for pointing it out because its not always obvious. I have double and...

I am still having issues with referencing the 3rd subform. I have used many examples that I have found on different forums and website etc but still cant get it right. Why is this so complicated? Any help would be gratefully appreciated.

The way I got around this was to include this code Forms!sfrm_ConvMaster!sfrm_DS_ConvDetailSub.Form!frm_DS_ConvDetail!cboOutgoingSize.SetFocus DoCmd.GoToRecord , "", acFirst I now no longer get the error when I use the 'Exists' part in my query

How do you reference a control on a subform within another subform that is on a Navigation tabbed form. Main form = frmMain Navigation form = DS SubForm = sfrm_DS_ConvDetailSub I can reference a control on the DS form with the following...

Just to add to my post above. If i click into the combo box and DONT select anything and then move to the next record in the datasheet (just by clicking on the down arrow on the keyboard), I can then select from the combo box on any record. It only causes an issue if I select from the combo...

Hi have a combo box on a datasheet that is bound to a table. The list is created via a query to a look up table. The user selects a size from the combo box for record 1 then moves down to record 2 to select the size for the next record. The issue is that I am trying to limit the list to exclude...