Search results

Is it possible in access to link to both oracle AND access tables in the same access application?

I have 2 fields printing out. They both have the 'can grow' property set to yes. It's working on one (this one is a combination of fields), not working on the one straight from the database. What could be wrong? Thanks in advance for any help.

I have created a form off a query. I made the form for adding new records only. When i bring up the form it is blank, the labels and fields don't even show. Anyone know why this is? Thanks in advance for your help.

What does it typically mean when the following screen appears. I am trying to open a module in design view and this is what I am getting: Microsoft Office Access has encountered a problem and needs to close. We are sorry for the inconvenience. Then you can check to repair the database...

Is it possible to call a function from a field on a form, ie, in the control source put = FunctionName(abc)? Then I want to concantenate it to another variable so it would look like: =FunctionName(abc) & TextVariable I tried this and got the ?Name on the form, like it couldn't find the...

I need to define a variable in VBA as a memo field because the string type won't work due to the length of the field. How do I do this when 'memo' is not an option in the list? Thanks in advance.

I am working in Access 2000. When I am in a module and type the 'docmd' the properties menu does not pop up. I checked the References and nothing appears to be missing. Anyone have any ideas? Thank you in advance for any help.

I need to change the height property of my fields on a form depending on how much text is in one of them. When I do this on the form load property, the data does not display. When I comment out this code, the data displays. I even changed the CanGrow/CanShrink properties for each field to Yes...

Is there a way to define a memo field in code? I don't see 'memo' as an item in the list when you go to define a variable. Thanks in advance for any help.

I am in Acess2000 and trying to go to put vb in. When I hit the code icon, I get the message: "name of db" failed to create the VB module '|'. Is anyone familiar with this message and what do I need to do. I just added this form, and in the other forms that have vb code already, I can get to...

I am trying to import a form from another access db. The access db I'm attempting to import into is Access2000, from an Access2003 db. I've also tried to export from the Access2003 db. Neither works but I don't get an error message. Any ideas? Thanks in advance for your help.

I want my table to update on my last record entry when I close the form. Now, I just have docmd.close under the Close button and the last entry didn't make it to the table. What do I need to do? Thanks.

I need to refresh my mind on something. When I try to update my 'Circuit' table via my form, I get a message that required fields are not in the table. I get 'Cannot insert null...into table' It is talking about trying to put a numeric ID key field that is required into the table, but since...

I have an autonumber field set up as long integer. The field just reached the value of 32670 and I get the overflow message. I thought a long integer could be much bigger than that before running into that problem. I got around it by re-creating the field and starting from 1, but would...

I created a form with a query as it's source. I am able to open the tables themselves and update them, but when I go to a field on the form I'm unable to update. What could be wrong since I have full update rights to these tables? I've checked the properties and they appear to be set correctly.

I get the 'this is read only you will not be able to make changes, etc.. whe I open my database. How do i fix it? No one else is in making changes.

Could somebody give me the code for the transferdatabase docmd? I get the message that it can't find the database I want to export from. Thanks.

How do I convert a date to a string? Thanks in advance for any help.

I have several date fields on my form. I need to check if there is a date in a field. My code is: if isnull(datefield), then... Problem is there is a date in the field but it thinks it's a null all the time. Any way to resolve this? Thanks in advance for your help.

Any suggestions on a print button right on the form. I need to be able to make changes to the data that is bound by a form and the users want the print button right on the form. The tables don't get updated since I haven't left the form (closed it yet). Has anyone run into this and found a...