Search results

Hi there. This is maybe not the right forum but since I'm messing around in my code, I'll start here. I'm lost about how to handle this problem. I got tree tables which I would like to mix together into one "flat" table. Tabel1 = Persons, Telephone, Fax ... Table2 = Company, Telephone, Fax...

Hi there. I want to import / link a FileMaker DB to my Access DB using ODBC, to eliminate the need of making an export from Access. The problem (or task :)) is that I need informations from more than one table at the same time. Is this possible? What I done so far is: Since FM is not able...

Hi there. Need an advice regarding those two products. Is it possible to "link" OutLook to the data from Access? It's and attemp to maintain only ONE database with customers but use the calender of OutLook to book meeting, apointments etc. I know how to make an import but I would love a...

I'm using a public function to calculate the difference between to numbers in %. To make sure I don't get a "Division by Zero" error I'm using a switch. The numbers come from a table where the datatype is Currency. The function works - but still it returns #Error on my report when there is no...

Hi all. I'm writing almost all my queries in VBA and in this forum I've learned that to save memory it's best saving the queries and then execute them. Often I'm using one query as a source for the next query (can't remember what it's called :( ) and all the queries containing parametres and I...

I'm writing a SQL statement in VBA and save it with a CreateQueryDef, but when I look at it (the SQL's) in the QBE then the sequence of the fields has changed. It's a INSERT statement but I don't know if it's makes a different. Can anyone explain me what is deciding the sequence of the GROUP BY...

Hi there. Maybe this is belonging to the Modules/VBA forum, don't know. I would like to hear what all you hard-core programmers are doing ;) In my applications the users shall specify a numbers of criterias (or parametres if you like) and based on those criterias I'm creating reports. I've...

Hi. When you are running a Append- or Delete query, Access ask you "You want to append 8 row(s) bla. bla. bla. Do you want to proceed? YES / NO" I'm running my queries from VBA and to make life a little easier for the end-users I want to get rid of those check-boxes, but I really don't know...

Hi there. I have been reading a looooot of posts regarding these subjects but I can't find a good ex. who helps me. I've seen that Pat is allwas saying that "if you can - use Stored QueryDefs (SQ)" and I would love to - but I'm in doubt about how. If I have understood SQ correctly then it's a...

This is what I got: Public VarSerie As Object Public VarNumero As Object Private Sub SeleccionarCategoria_AfterUpdate() Set VarSerie = Me!SeleccionarCategoria Me!SelectAlbaran.Enabled = True Me!SelectAlbaran.Requery End Sub Private Sub SelectAlbaran_AfterUpdate() Set VarNumero...

Hi there. Just can't find the right syntax... I got two listboxes. The first contains 2 catagories and the second is supose to contain the records of the catagories. I'm using a simple SQL in box2 to select the records, and I want to use the value from Box1 in my WHERE clause - but I can't...

Hi there. None of my books describes how to "breake" a SQL statement which is more than 255 char. long?? Following statement gives me some trouble...: Sum(IIf([divisa]="PTS",([Importe Neto]/[Cambio]),[Importe Neto])) AS FactSin I've tried with #, &, ', and a lot of other char but I can't find...

Hi there. I need some wise words regarding how to "attack/solve" this task. - I got a acounting system, based on Access -97. - I got a logistick company which is taking care of sending out our books. - I got every day an amount of packinglists from the acounting system, which I'm sending to...

Q: Is it not possible to use IIF to "modify" the same field as it's testing? Exampel: In a report I want a 0 if the field is empty. I'm using this syntax in the source-property-field: =IIF(ISNULL([field1]),0,[field1]) Field1 is of the type: Currency Pls. tell me where I'm doing wrong :-)...

Hi there. I've been working with a Q in Access -97 on my pc which is a Windows 2000 Adv.Svr. and everything is working fine. Then today I was going to exe the same Q from a Win 98 (800Mhz, 128Mb) and I get the error '3071: Q is too complex..." I've checked that all the same tools, drivers...

Hi there. Now I've been searching the web for days, without any luck hope U can help me. I have 20 different regions and 53 different provinces. Each province has it's own group of zip-code. ex: COMUNIDAD VALENCIANA 03 Alicante 12 Castellon 46 Valencia As you can see there is no connection...

I've must have turned blind because I can't see what's wrong... The field C Postal is an textfield. SELECT DISTINCTROW Left([C postal],2) AS zip, [Ventas de postales].[C postal] FROM [Ventas de postales]; Best regards El Vikingo

Hi there. I need a little help to get started. I'm working with a financial program (Visual Factu) based on MS-Access tables, and I have to create some new reports. The report I'm fighting with right now is suppose to make a list of how many bookes there has been sold and for what price -...

How to "attack" this problem...??? Hi there. I need a little help to get started. I have a financial system based on Access (Visual Factu) and I have to create some new reports. The one I'm fighting with right now is suppose to make a list of how many books there has been sold, and for what...