Search results

Hi, I have a date field with a format of 'Short - dd/mm/yyyy'. All of the data stored in that field is in that format. I have a listbox that displays all those dates. I select a date, then click on a button to filter the form by the date selected. Here is my code that fires on the cmd_Click...

Well so far the AutoNumber has been working fine. I have never had any conflicts, and it seems like the chances are pretty slim. I agree, using 2 fields will lessen the chance of a conflict, but with the small amounts of data that are being entered I am not too concerned about that. So, I am...

OK, I think I follow. But...in my situation I have 4 tablet PCs that users are taking into the field in a 'disconnected' state, and using the database to collect data. So I think I need a backend on each tablet. Currently I am using a Design Master on a central server, and then 4 replicas...

Hi, I have a database that I have successfully replicated. It includes forms, queries and tables. Synchronizing works and all is good, but.....from what I keep reading on this forum, this is not the proper way to do it. It sounds like what I should be doing is splitting my database before...

Hi, I'm creating a DB for use on a Tablet PC. Users are finding it too hard to hit the scroll bar with the stylus when they need to scroll in a combobox. Any idea what code I need to add to two buttons (one up, one down) to control the scrolling of the combobox?? Or....is there a way to...

Ah, it seems like Access will accept ActiveX components but not .NET.

Hi, I have an SDK that I normally use with VS.NET. I cannot seem to add the .dll as a Reference in my MS Access 2003 database. Is there something I am doing wrong, or a workaround to get it to work? I have .NET 3.0 installed on the PC. Thanks,

Well, each control object has a 'Top' and 'Left' attribute, so you could adjust the position of each control according to the size of the maximized window. Of course, that would take a lot of code and logic to figure it out properly.

I find that putting DoCmd.Maximize in the forms OnActivate event seems to work best. That way regardless of wether you're opening it for the first time, or coming back ot it after opening another window, it is always maximized. Also if you slap a DoCmd.Echo false before it, and a DoCmd.Echo...

Hi, I am running an Access database on an Xplore iX104C2 tablet PC to collect data in the field. I need to transfer the GPS coordinate the tablet is receiving into a field on a form. Any idea as to how I can get this information from the PC without using any 3rd party software?? Thanks,

Replica DBs that are stored on tablet PCs and taken into the field. Once they return, I want them to replicate to the Master. That is not a problem. But....if I make a change to the Master I would like to be able to update all of the replicas in one shot assuming the tablets are all connected...

Hi, Is it possible to synchronize to ALL replicas using a command button in one shot from the Design Master?? I've read various posts, and it doesn't sound like anybody has found a solution for this. Found solutions for doing it one at a time, but was wondering if anybody has found a way to...

No, the tablets won't be connected to the network while the edits are being done. So I will try using replication instead of splitting. Or is it better to do some combination of the two?? The users will be using forms to enter data, so if I ever need to change the form at the Master splitting...

Yeah, I've been doing some research and it looks like 'replication' is what I want to be doing. I read a post on here that says I should be splitting my DB and not doing replication though. Why would I choose one method over the other?

Hi, We have a relational DB that holds information on West Nile Virus. Currently, we have 5 tablet PCs that take a full copy of the DB and updates/edits are done in the field. Once a month, the tablets come back and someone manually takes the 5 databases and uploads the changes to the central...

Actually, by searching on 'combine rows into one field', I found a nice bit of code that created a 'Concat' function to combine them the way I needed. Thanks!

Hello, I need to find a way to modify the following structure: Name, Page, Grid Acton Rd, G10, 12 Acton Rd, G10, 4 Acton Rd, G10, 8 Adams Ct, F6, 2 Into something like this: Name Page Grid Acton Rd, G10, '4, 8...

Hello, I am using the following code to create a new SQL CE database: Dim engine As New SqlCeEngine("Data Source = \My Documents\test.sdf") engine.CreateDatabase() That code is directly from MSN, and I am pretty certain it is correct, but I keep getting an exception thrown on the 2nd line...

Hello, So from what I have read and experienced with my new Windows Mobile 5 PDA, is that Microsoft no longer supports Pocket Access. On my old PDA I could use ActiveSync to automatically convert an .mdb to a .cdb, but with WM5 this is no longer possible. So....for my custom PocketPC apps...

Hello, I actually answered my own problem here. With the row height problem, it was just user error with the query I was using. With regards to the borders question, here is a posting that answers it...