Search results

Personally I think it's a bad idea and would rather see just one donation group instead. I don't see any value in people buying membership. I don't care about ads and a private discussion section would be pointless. Perhaps you could set up an option for people to join an access course or get...

It's because your variables are Strings - text only Change String to Integer where you want to hold numbers.

Can you attach your spreadsheet so I can understand exactly what you are trying to do? You can change the values or whatever if it's confidential.

It doesn't matter, the important part is: Are you running on 32 bit?

Ok I noticed I can change it, but it's not what I want. Is there a way to zoom into the chart to see only values from the min number plotted to the max number without manually having to do it?

Hey guys, Anyone good with Access charts know if it's possible to change the value axis values. I create a chart getting values from a query I run, it plots the values but auto selects the value range and the increment. The values on the value axis are: 0, 0.25, 0.5, 0.75, 1 Is there...

Try this: Format([Me.arivaldate.Value] + [Me.arritime.Value], "dd mm yyyy hh:mm") Edit: opps noticed you're using textboxes remove the [] from both.

This post may help you, can be found here: http://social.msdn.microsoft.com/Forums/en-US/accessdev/thread/89d0b01c-2b6c-4875-bdac-7cb4f6de3a53/

Ok just so this is clear to me you want to run a query which will find a user who has more than two sweep's in the task, with one sweep in the process and one other non sweep in the process? What if there is: sweep sweep 123 sweep sweep 123

I think Paul Eugin thought all three were text boxes. Use the method you had before for the combobox, IsNull.

I'm a bit confused, so you want to select records where the account has more than 1 process which includes a sweep process? So what is the Task column with all the sweep's?

Paul is right, my god, how did I not see that. I wasn't really paying attention to the logic just the method to check the textbox. :D I have always used .Text, don't like using Me., I don't remember using setfocus though. To be fair I haven't really used text boxes in access much. Been near 3...

Try this: If (Len(Trim(txt_date.Text)) = 0) Then lresponse = MsgBox("Please insert today's date", vbOKOnly, "Warning!") ElseIf (Len(Trim(txt_call_ref.Text)) = 0) Then lresponse = MsgBox("Please insert a call reference number.", vbOKOnly, "Warning!") Else lresponse = MsgBox("The Form...

I would import the excel file into a new "dummy" table. Run a update query to compare both tables records and change validTo on the original table where the records aren't the same. Then run an append query to move new records to the original table. Then delete the remaining records or do...

Well for the text boxes you should be able to do something like: If (Len(Trim(Date.Text)) <> 0) Then .... Just as a side note I wouldn't use "date" as a textbox name, can become confusing, I normally stick a letter before the word date. Edit: sorry noticed you were checking if it was an error...

Are Date, Call_Ref and Logged_by textboxes?

http://stackoverflow.com/questions/1503959/how-to-count-occurrences-of-a-column-value-efficiently-in-sql You should find examples in there that should help you.

I'm not sure, maybe someone more experienced would know. I'm pretty sure you can though.

Surely if the SQL works in a long line, the concatenation should work as the code is fine. Will rut not being capital like the first statement affect it?

Now I'm confused, I thought it was on the same db after it got imported?