Search results

Thanks boblarson Much better !!

HI I have a db built for several users & I have it on a Network drive but if I split it, the users get the forms flashing up for a moment & dissappearing. As I need more than one user to enter data, I want to split the db, but need the db to work normally. Has anyone else had this problem...

Thanks to all for your input, I've tried this code but I still get the hourglass & I did suspect that it's a Windows thing (as boblarson mentioned) that is more difficult to turn off. As this is a 'nice to have' feature only, I'll try to deal with it another way. This hourglass was only...

Hi I need to run a couple of small procedures to update numeric values on a form. I don't want the users to see a flicker of an Hourglass while it does this. I've checked on some syntax like the below, but the Icons keep appearing. Here's a code example; Private Sub Question_Click()...

Here's the answer without using DMax for anyone who wants it. I couldn't use DMax as I couldn't refer to a table or query, I just wanted to hold the last or highest value for a numeric field & add + 1 each time a new text field was created by the Continuous form. Movelast was the answer as...

Thanks for that I've adapted your code to suit my form but am getting an error using DMax. any ideas?? Private Sub Form_Current() Dim max_sub_no As Integer If Not Me.Sub_Issue_No Is Null Then max_sub_no = (DMax(Sub_Issue_No)) End If If Me.NewRecord = True Then Me.Sub_Issue_No = max_sub_no +...

In case anyone needs this, here's the code syntax, Private Sub send_to_excel_Click() DoCmd.OutputTo acOutputReport, "Report_Name", acFormatXLS, "C:\Documents and Settings\rest of path to Excel file you want the report sent to.xls", True End Sub

Hi I have a Continuous Sub Form with one of the field names as Sub_ID & I can't use Autonumber as a datatype. I have it as a number data type & I want it to increment + 1 as the new field appears. So the user fills in the continuous form which initially is set to a default of [Sub_ID] = 1...

Hi I want to produce a report that can group up to 3 levels of data in a report - same as Access allows in the Report Wizard & then export it as an Excel file. I can only do this manually at the moment by creating the grouped report using the Wizard, on 3 parameters, going to design view &...

Thanks dfenton SOS & Galaxiom for your input, Re the response - Replace(FieldName,Chr(34) & Chr(34) & Chr(34), "") What is Chr(34) & how does it work?? dfenton, No reason why this wouldn't be satisfactory, I just don't follow how it works & it hadn't been posted as a possible solution...

Thanks John Big Booty Would never have thought of MID & LEN for this purpose. So now I get it that Mid([ItemName],4,Len([ItemName])-6) is useful as - The MID function starts at '4' as this is the first letter I want kept after my 3 " marks & the number of letters it returns after that...

I have No idea what you're talking about........

Yes, can you help? I want to do an Update query in the query builder to remove the quotes.

I can show you an example right here; What I have now; Fieldname """value""" """value2""" """value3""" What I want is; Fieldname value value value

Hi The actual field names, not the field heading. The names vary but they all currently have 3 quotes at the start & also at the finish of the value.

Hi I need to remove quotation marks from the field name column in an Access table. The fieldname can change & I currently have 3 sets of quotes at each end of the fieldname. I've tried a few versions of Update statements but no luck, can anyone help??

Hi Brian I'm impressed with your tenacity! I should explain what this is designed for as it will make more sense. This will be a tool to use for Customers 'Take up' of products & perhaps show trends of behaviours when a product is purchased & afterwards. The point of looking for '0's is...

Thanks Brian This definitely helps!! This is more useful for my purpose than Cells.Find so thanks for your time, Cheers : )

Hi Brianwarnock Q1 What happens if >0 is before col F - I was going to add some code that just copies what is available to the left of the first cell > 0 if there aren't 6 available. (If you have any suggestions, pls advise) Q2 Do you mean copy 12 cells from that row to the new sheet or...

Thanks Chergh Can you give me an example that fits within this code sample? I saw some examples where I could put in a range of cells into the 'What' section but it only picked up the first value, your solution sounds better but I'm not sure where to start as I will have 1000s of potential...