Search results

unmarkedhelicop you are an ACE. Thank you very much for your help. My first "xxxx" is not always 4 charaters but with what you provided for me I could do what I wanted.

Hi there Does anyone know where can I find a tutorial for working Access with Excel? I receive regulary a spreadsheet with information that I need to copy to the access database. I can do this manualy but I would like a query that could do it for me. Thanks to your help

Hi I’ve got dough and I would like to know if someone could help me. I’ve got a cell on a spreadsheet whit following values: Values xxxx,1,core3 xxxx,115,core3 Is there any formula to pick only the numbers between the comas not knowing if will be there 1 or 2 or 3 or more numbers. Example...

Thank you The_Doc_Man for your help

Hi everyone Can someone explain me please the difference between AND & EQU? I'm using the following code: if (txt1 > txt2 AND txt1 < txt3) then This doesn't work when I run the program. Is there anyone that can tell me why? Thanks

Hy guys I've got two tables and some of the information is inserted in booths tables. By example, if I have the numbers 1 and 2 in tableA and the number 2 and 3 in tableB, I need a query to display only the number 1,2 and 3. Thanks to your help Joao Beca

Hi there Is there anyone that could help me and tell me where can I find a tutorial where I can learn how to use spreadsheet 10.0 object or spreadsheet 9.0 object. Thanks in advance for your help. :D Joao Beca www.joaobeca.co.uk

Hi there! I'm bulding this database where the user will have to insert a full phone number. What I would like to know is? if is there any way where Access can pick the first 5 digits of the number to compare with information already imputed in. by example if the user input the number...

Hi there. As Im begginer on VB.NET I wondered if someone could solve me this easy problem. 1 - what's the code used to switch form when clicking an button? something similar to this: DoCmd.OpenForm "frmTest" 2 - how can I change wich form to open when I debbug an application, like on VB Access...

Hi Brian! I've on more problems on my report and would like to know if you can help me. When I run the report it creates one-second page totally blank. Do you know how can it be stopped? Thanks for your help JonyBravo

Thanks Brian for your help :o JonyBravo

Can you explain me better please about group header? Thanks Jonybravo

Yes, im getting it from a form. It's more like that. txtcharges = DSum("[Charges]", "tblcharges", "[DateCharges] >= '" & [forms].[frmCharges]![startdate] & "' AND [dateCharges] <= '" & [forms].[frmCharges].[enddate] & "'") Thanks

Hi! Ive got a table with three fields, one called name, other surname and other teamsupported. I want to run a report that when I run it, it will show me the head of the report and the supporters of the team 1 and then the head again and the supporters of the team 2. This means I want it to...

Hi! Can someone tell me why the following querie doesn't work? txtcharges = DSum("[Charges]", "tblcharges", "[DateCharges] >= '" & startdate & "' AND [dateCharges] <= '" & enddate & "'") ' Thanks JonyBravo

Thanks Karma, it works perfect. Could you tell me please in the similar situation but if instead date my table field is Autonumber what code should I use instead of #" & txtnumber &"# ? Jonybravo

Hi there! I've got the following code on my database: strcriteria = "[date] = #txtDay1.value# " Set rst = dbs.OpenRecordset("tblPlanner", dbOpenDynaset) rst.FindFirst strcriteria The problem is when I run the code it have the following error: Run time error '3077'...

Hi! Check DCOUNT statment where can be used for something like this: textbox=DCount("[fieldflights]", "tblflights", [fieldcity]=' " & txtcity & " ') by example now: if you type london on txtcity it will count only the flights where on fieldcity is recorded London. Hope this help..... JonyBravo

Hi! When you imported the form did you check if it has any module? JonyBravo

Hi! The information you provide is not enough but I think it is not working because you are not using maths rules properly. Is many ways you can put the info received by the equation into a field and I give you here one example: Dim dbs As Database, rst As Recordset Set dbs = currentDb Set...