Search results

This is a web database i am building. I've tried to create a Pass-Through Query for my ODBC tables, but I recieved an error. Which I have attached as well as my db. I'm also not very good at writing code, so thats probably lacking as well. I could use a little help there. This is all i have so...

Thank you Mailman. Your pass through query idea helped. For some reason the ODBCs don't show up if your trying to do a Web Query, but they do if you do a Query Design as it says to do when I looked into Pass through queries.

I guess I should make sure this is clear, that I am doing a web database. I need a query for each of the ODBC tables to use to pull specific columns to fill one or two fields on the form from a combobox. My ODBCs have way more info than I need for my form. All I really need for example from...

How do I go about that? Cause when I try to do create a query the ODBCs do not show in the tables list.

Yes the way my tables are setup is intentional. It was the best way to get my form to work the way I want. I do know about and understand normalization.

I have Linked a few ODBC Databases to my database in the Tables objects. How do I make them usable for queries or as record source for my form? I tried to create a query but the ODBC databases do not show up in the Table options. Database is attached. Any help would be much appreciated...

I think I got the On Load visibilty. I SetProperty on each field to Visible False in the On Load for the form. And its working like I want.

How do I set the 'CustName' 'CustID' 'SupplierName' and 'SupplierID' to not be visible On Load for the form? So that the person filling out the form has no choice but to select one of the checkboxes. Still has to be a Macro since its a Web database.

Its for a Web Database. I pushed the ... button on the AfterUpdate and it takes me to an Embedded Macro. But I figured out what I needed. Thank you. I attached the Macro.

The Macro still worked when I checked the box with just 'ckbCustomer', it just gives me the error if I click run while in the Macro Builder. But I'm also trying to make it work for two fields to become visible once its checked. 'CustName' and 'CustID'. I tried just putting 'and' in between them...

Nevermind on the error it doesn't seem to affect the outcome eitherway. The macro still worked just fine. Even though it says the same thing when I run the Macro with 'ckbCustomer'. But I'm also trying to make it work for two fields to become visible once its checked. 'CustName' and 'CustID'...

I'm trying to setup a Macro for two Checkboxes in my Web Database, so that when one of them is checked two other fields become come visible for input. I have ckbCustomer and ckbSupplier. I want ckbCustomer to make text box CustName and CustID visible and ckbSupplier to make text box...

I read about the lookups in a couple other threads on this forum. I don't remember which ones, because I have read so many different ones looking for some answers to my issues. But Thank you very much Jeff, I appreciate all your help and advice.

When I first tried to upload it to SharePoint the web compatiablity checker said it was incompatiable with the lookups at table level. And what I have read from other posts creating lookups at table level are not recommended for web databases. But I believe I found the work around for the...

Ok I attached the backup verison of my database on my first post. Also the SharePoint version is in Read-Only mode, how do I change that?

I created a web database for use on SharePoint. And I was able to publish it to SharePoint today. But to make it web compatible I had to remove my row source Data I used to make my combo boxes fill the way I needed them to. I created these on the form Property sheet, not using a lookup in the...

That what almost what I wanted, I just had to reverse the "closed" and "open values. But thank you Access

I'm tryin to create a Macro in a Web database form for my 'ControlCloseDate' date field on the AfterUpdate event to change my 'Status' field to "CLOSED". The code below I used when I created a regular form and it worked like I wanted. How do I recreate this in a Macro? If ControlCloseDate...

Hi, i have some experience using Access 2007 and 2010. I live in Indiana in the US.:)