Search results

What name do you expect for the output file? I ask because the constructed name is "T:\Admin\PACCT\CBO Billing ReportWeeklyHeldClaims.xls" - which looks as if it may be missing a "\". Does the file get created if you use a local drive (e.g. C:\)?

... Might be worth adding that RACF is a clue ... This indicates an IBM mainframe which possibly uses EBCDIC code, so the origin of the dat file may be related to the data type.

The numbers you see are the hexadecimal equivalent of dev.racf. This reflects the way the field is stored as a null-terminated string. What is the data type of that field?

It seems to me that your code deletes all records in [Primary Revision], leaving the table empty by the time you hit Me.Refresh at the end of UpdateMyForm. I just tried a graph with and without data and its behaviour reflects your symptoms (i.e. the graph is blank when the table is empty). If...

I don't see enough detail here to answer your question:( Can you post your query at the point where it works, then again with the Boolean fields added where it doesn't work? My first thought was around the FK for table 3 which has some null values, but your subsequent text suggests that isn't...

I used the name Graphcontrol as a dummy - so changing it to your own control's name is correct. Has the data source of your graph been updated by the time you execute the requery? It sounds like you need to update the table(s) to which the graph control is linked. Check the linked fields in...

Use the control's AfterUpdate event instead of its Change event handler. Try requerying the graph's data source in the form.Me.GraphControl.Requery

The SQL parser is confused by this clause - maybe where tbl_WS.Wcode appears in two separate joins(?). I would start by resolving the innermost joins to individual queries which have a common field, then try the crosstab query using those queries as its data sources joined by the common field...

In what way does the problem show? Do you get an error, or does the constraint fail (i.e. more than <limit> is allowed)? Also, are you using the validation rule in the control (what is the exact syntax?) or in the click even of the combo box (what is the code?). You say you use column...

Try changing this toinstitution.value=rst!OrganizationThe difference is that .Organization refers to a non-existent propery of the query, whereas !Organization refers to a field of the query. You need to make the change to all of the query field references in your code. I notice you re-open the...

Hi Jon What do you see as the advantage of moving the profile position? The main concern I have is visibility of content when using my iPad. I often look at the forum when I'm not at my PC, then answer the points where I can help either from iPad or when next at my PC if I need to test...

Yes, price changes are much the same as tax changes or any other financial deviation such as manufacturing and transport costs. In an ideal world I would advocate the maintenance of historical data and I would encourage the change in any input variable to be maintained in a journal of some...

You're very welcome. :)

Well, we don't all agree here, but that's OK:) If you look at the problem from a purely technical point of view, then the arguments are valid. However, if you look at it from a business point of view, you have to cater for the dynamics of change - both historical and future - hence my...

It looks like its working properly to me!:) The 719 days is the correct result for that row. What the calculation is saying is subtract 31 December 2009 from 20 December 2011. That is 365 days in 2010 and 354 days in 2011. What I suspect you want is the difference between the order and...

Sorry - more haste, less speed! I didn't test the code (self evidently!) - I started with a 'Do While' loop, changed my mind to a 'For' loop, then didn't change the loop termination statement. Just change the 'Loop' statement to 'Next', givingPrivate Sub ComButton_Click() Dim i As Integer For...

If it is literally that code in your click event, why not just add the textbox number to the field?Me.FieldName = Nz(Me.FieldName, 0) + Val(Nz(Me.txtBoxNumber,0))If you need the loop, then try thisPrivate Sub ComButton_Click() Dim i As Integer For i = 1 to Val(Me.txtBoxNumber) Me.FieldName =...

What do the groups represent? Are these identified by a field in a table whose records also contains the other details as fields? You need to give more context in order to get sensible replies!:)

You are very welcome.:) Did you manage to run the query successfully?

I have attached a sample file which does what you describe. This is compatible with Excel 2007 and 2010. There is a command button on the worksheet, which opens a user form with data entry textboxes for three fields, starting with the active cell on the worksheet. I have also included two...