Search results

I have a table in MS sql Express that I need to use in queries for my database. I've set up an odbc connection, and I can view the sql express table in Access. However, all of the double fields in the sql table display as number fields in Access, and they are a very odd format. For instance...

How do I check the drivers? We've tried exporting from Filemaker to a text file, but we don't get all the records. The same export produced a different number of records each time we ran it, so we don't trust FMP's export.

Our organization has a very old Filemaker Pro database, and no one here has any experience with Filemaker. We need to pull out all the data and put it in our Access database. Unfortunately, from Filemaker, we get a different number of records each time we do the same export. I am trying to...

Yep! That works. Thanks for saving me all that trouble trying to get margins and fonts the same!

I work for a state, and governments do love their forms. We have payment data in Access 2003, and the state requires us to make a payment request using a specific form that they created in excel format. We'd like to re-create the official form in Access, so our admin person won't have to fill...

I'm sure the answer to this is quite simple, but I'm not a programmer by trade and simple things catch me all the time: I have a treeview on a form. When a user clicks a node on the treeview, one of three forms appears in an unbound subform next to the treeview depending on which level node is...

I have a main form that contains basic project information, and one of many subforms that contains project manager and contract information. (forms and subs linked by project ID) My project managers want to have the ability to only show project records that are theirs. I can make a filter...

Thanks! looks like I have a couple of solutions now!

Would that prevent them from entering new project names for new projects?

I created a form for project tracking. The form has a project name field in it that is a required field. The manager fills that out first, but may go back later to fill in additional data. I created a button to allow them to search for a project name, but they keep opening the form and typing...