Search results

It's working for me now too. Some reason the file bugged out on me. I found a new problem now. It seems that I can't assign the main form's ID number to the DocField table as the form's ID is still on "Autonumber" or null value when I make a new record. Is there a way around this? It has...

Already tried that there. It's still pulling up the entire DocFields table instead of just selecting the matching IDs for some reason.

Thanks this is what I was looking for. But it still doesn't work properly. It doesn't seem like the SQL statement is taking effect at all.

Maybe this clears things up more. Issue is that the combobox pulls up the entire DocField table instead of the entries with IDs that are linked to the form's ID.

I am trying to be able to simulate the ability to attach documents onto each form of the database by storing Links to files inside a combo box. However ... I can't make the combobox store the links after one closes and reopens the form Sourcing the combobox to a table/query causes the...

I am using Access 2003 Also using this method, causes the combobox to pull out the same table/query list each time. I'm trying to get each form's combobox to pull up its own list. Is there away to do this using One-to-Many relationships?

What command would I use to append items to the combo box now with this method? combobox1.AddItem no longer works.

I'm saving links to a combobox in a form, but each time I close out of the form and reopen it the Combobox doesn't keep the list of data I entered before and only keeps the last selected one in its drop down menu. Is there a way to make the Combobox store/keep the data?

I have issues opening a 2003 Access database today where it says one of the forms couldn't be opened and clicking through the prompts brought me into the VB editor window showing the form's class object code page..however it was BLANK. Completely blank... all the many pages of coding...

Here is the link. This seems to happen only when i try to attach a link of a file on my own computer. All the computers are on a network. If i attach files that are on the network it doesn't seem to reject the link like it does on the local files. Second issue I have is that when I pull up...

Thanks, this method is much easier. But I am getting an error some times saying: when certain hyperlinks are assigned to the table.

I'm trying to use this API in my database to be able to attach documents to my forms. http://access.mvps.org/access/api/api0001.htm Do I have to put this into its own Module? I'm not familiar with how the code is defining Types and declaring Global variables.

Is there a way to open a specific Access record upon clicking the Access mdb file?

I have created a unit converter and I have a text boxes that output weight or length based on the calculation below. However, sometimes the text boxes won't display the calculated value despite clicking on the solve button. Could it be an issue with multiple users writing to the same record...

Re: Access GUI into Code: VB Extensibility I'm creating this for someone else. They would have no knowledge of VB programming. If I was doing it for myself, I would just obviously write the code each time I wanted to add a new conversion. Hence I was trying to find a method for them to define...

I'm trying to create a unit converter with the ability to create new conversions. The Access environment of course allows us to go create code in Visual Basic and that correlates to Access's GUI environment. Is there a way for user input from Access fields to be brought into the Visual Basic...

Can anyone give me some info or where I can learn how to pull data from Navision database into an Access database? I'm trying to create a better way to search through data and I thought somehow creating a table interface off of Navision's data would be easier than manually "wildcard" searching...

Edit: Access should automatically update subform data when you change focus out of a subform. There has been cases where this won't happen for whatever reason. Perhaps you should write something that saves the subform record using on Dirty or change focus or something.

IT has destroyed your company? :p

Can't the Primary Key just be assigned to an autonumber that doesn't play any other part in your database and is hidden from the user? And why are all your auto IDs out of whack? And does it even matter? Shouldn't they have been set to not duplicate by default? And what are u using the auto IDs...