Search results

Yes, thankyou for the demo. I will study it when I have a moment or two. Sorry but have been put on another project that has been taking up the majority of my time. I do appreciate the help. Also yes we all users have a full version of access. Thanks again

In order to give users more flexibility. I would like to create a report that uses a selection from a combo box, on a form, to Group on and be displayed in the Header. I have tried multiple things but unable do it. Is this possible? or do I have to copy and paste a bunch of reports with the...

OK I will simplify the question. Is there a way to glean data from a crosstab query by using 2 sets of criteria? 1 being if there is data in a cell under a particular column header, i.e. Employee Name and 2 for a particular date. If so how would I write an expression to get all of that...

Sorry if I didn’t explain myself very well. What I would like to do is create a report for a daily time card summery with a page header as the employee’s name, along with some miscellaneous information. I have that down. The following is the SQL for my cross tab Query. TRANSFORM...

I hope I can explain this clearly. I need to build an expression using information from a form to get data from a Crosstab query by using a Row header and a Column header. How would I go about doing this? Thanks for your time

I thought I would have to do somthing along that line. However I did not know if there was a insert cammand/code of some sort. Thanks

I have a combo box that gathers data based on a query. Is it possible to add a line of text to be displaed every time i pull down the box? For example I have: Data1 Data2 Data3 I would like to have: Not In List (the added txt) Data1 Data2 Data3

Sorry for the delayed response. I was called away to another project. I was able to get it to work. I found a type-o in my code. Thanks for your assistance. I appreciate it. Below is the full code for FYI. Private Sub Cancel_Click() DoCmd.Close End Sub Private Sub Form_Load()...

When I use that code I get an error. Run time error 2465 Application-defined or object-defined error

I have several different reports that I would like to open from a single form depending upon what the user selects. Is there a way to use a SQL for the name of the report in the DoCmd.openreport command? Or do I have to use a cascading string of If statements? I have code that places either...

Thanks!! The Eval() worked. Appreciate the help.

I am trying to use an array in a If statement inside a For loop to cycle through serveral check boxes on a form. The For loop works but the If statment gives me a Run-Time Error '13' Type mismatch error. Is it even possible to use an array in a If statement? An excerpt for the code is as...

There will be about 4-6. Unsure if I want to incorperate the last 2 yet. And no they will not be dynamic. It will depend on what the operator checks on the form. Thanks again I'll give this a whirl and see what will work the best.

Yes it does i forgot to delete the sst(i)=i statement. Thanks a bunch

Ok I made it up as an array. with code as follows: Dim sst(3) As String Dim i As Long sst(0) = "OOS" sst(1) = "PM" sst(2) = "CAL" For i = 0 To 2 sst(i) = i Me.[Variable_Field] = Me.[Variable_Field] & sst(i) & vbCrLf Next i The output is: 0 1 2...

I am looking to simply loop through serveral variables in vba. I know this should be simple but I am struggling. str0 = "OOS" str1 = "PM" str2 = "CAL" For i = 0 To 2 Generate_VField_Loop: sst = "str" & i frm![Variable_Field] = frm![Variable_Field] & sst &...

@Pat – The caption property is blank. @spikepl – That’s pretty much what I have been doing. However it’s slow, but thanks for the suggestion. The reason I have to do it the wrong “clunky” way is because of our file server system. You place your file/db on the file server. You than locate...

OK so no answer on this question exists. Let’s go about it by way of another avenue. How can I change the name of the table so that it will propagate the new name to all of its dependencies?

My data and program are together so no I do not have a FE/BE db. The simple answer why I would like to do this is, is TIME. I have close to 30 tables, and that takes time to bring in the data into each one. I want to have two control buttons on a form. One to export all tables to a single...

With changing the acSpreadsheetTypeExcel9 to acSpreadsheetTypeExcel12 and not adding a file extention for out_file = CurrentProject.Path & "\excel_out". The xcel file is saved as a binary file (xlsb). However still no help with the name changing problem. Dim td As DAO.TableDef, db As...