Search results

Doesn't that require a web hosting ? I've not really used dap much, will it save locally and update on command?

The client can't afford a web front end, SQL Server Replication will just send the amended data 'on syncronisation' but you need to create the 'elusive' connection in order to be able to do it. Unfortunatly the data will be updated from both ends so it needs to be replecated, I can't just...

OK I want and access front end with a SQL server back end using SQL Server to pull the replication accross the intenet. I'm having trouble setting up either ODBC/OLE DB or ftp with access to connect accross a WAN, it's fine over a LAN but it doesn't like going accross networks. All the...

Can it be done?

You asked for it........ and now for a little explanation. If you've done a fair bit of VBA it shouldn't look too unfamiliar (hopefully) This bit opens the recordset, but dap should already have done this for you Set sqlsearch = Server.CreateObject("ADODB.Recordset") sqlsearch.Open...

where is the comma, is it in the table or coming from a form? If it's the table then you can change the format in the table design. If it's coming from the form then you can change it in the properties of the element on the form in the from design.

what does it display now? what format is it set to?

You can set an If condition for it If variable = NULL Then Else ....your code here End If

I'm not sure that you can call the vba from there, but you can put the vba code in to your dap (I think), it might need a little modification though. Done any ASP......??? I've built a website that exports filtered recordsets into an csv file. so if you want to go down that route I can give you...

Your syntax is wrong to start with try this strTemp = "(Thdsize = " & Thdsize_FieldValue & ")" If it's changing the comma to a decimal then try this Temp1 = Replace(Thdsize_FieldValue, ".", ",") strTemp = "(Thdsize = " & Temp1 & ")" It might be changing the comma to a decimal because your...

Grasping at straws but I seem to recall a "Call Shell()" command, with the file path in the () that will open programs. you'll probably need to check to see if outlook is open first though hope this gets you started at least

I think real time updates accross the net with access is a bit abitious. Access will replicate databases which can be synchronised. I think there's quite a hefty data transfer 'on sync' so unless you can chuck oodles of cpu/memory/bandwidth at it, irregular syncs are the way forward. If you...

Sorry. I meant replication.

How big are the tables your running the queries on and how complex are the queries

Does anyone have any experience of this. Is it advisable or should I look for another solution.

You need to specifically declare the condition at each or, so, (MACOM) = '" + frmUnit.Login.userName.getText() + "'") OR (DIVISION + MACOM) = '" + frmUnit.Login.userName.getText() + "'") etc.. hth

There's no easy way round this I'm affraid, Access doesn't really support 'Fuzzy Logic' like that, you'll have to build it in yourself. The way I get round the problem, if I'll be using it often is to build dozens of quries and use macro's to run them. What I do is to create a new column and...

I think the cap (certainley for excel) is 255 or 256, I think Access also has this limit for the number columns your allowed per table??? Personally I'd use SQL Server if your dealing with anything that big, otherwise you'll have to break the table up!

Buttons and other elements have an OnDoubleClick event in the properties, you can format the button to look "almost" like text.

hth = Happy To Help :rolleyes: If your doing that many then I would suggest you use a vbscript to format the file useing the fileSystemObject. Heres an example of a script I used to split up a database that was populated in just one field. It counts along text for x number of characters then...