Search results

Hello, Why is there an input mask if it's a combobox lookup? Also, since you've deleted the control and tried to re-add a new combobox using the wizard, try a few of the following: 1. Create a combobox with "I will type in what I want" and link it to the correct control, and tell me if that...

Ok I believe I found a work around. I will make Form2 have the tblMain ID on it and hidden, and the subform will have all the info from Table2. So when the button from Form1 opens Form2, it'll be able to find the data since it must exist for the button to be pressed. And the userwill only see...

Hello, Slight problem getting this to work... Let's say I have tblMain and tblSub. tblMain has an ID, and tblSub has an ID2 Autonumber, ID (Linked to ID from tblMain), and then some other fields. Form1 is based on tblMain and Form2 is based on tblSub. I have a button on Form1 that is...

Hey, I got it working with appExcel.Rows(intTarget).Select appExcel.Selection.Copy appExcel.ActiveSheet.Paste Thanks very much! So I'm assuming that as long as I use appExcel.whatever I can use any VBA things from Excel itself?

Thx Bob, I will take a closer look at that example and try to utilize it. I am uploading a txt contaiing the code for my procedure. However, the most important part I wish to change is this: 'Input the Objectives and Targets database information into their correct Excel locations Do...

Er, because of what I need, I will definitely keep the Excel template. As for using the correct objects, are their any examples that use code for formating Excel etc, and/or SelectionCopy.Paste? I will paste some of the code when I'm back at work this Friday, it's not optimal and I havent...

Hello, I have a database which has a VBA procedure that takes lots of data from the tables, opens Excel up in the background, uses a template to paste in the data into the correct places on the Excel sheet. Unfortunately, because of one to many relationships, rows have to be added in certain...

I have a degree in Information Technology where I took 1 Course in Database Systems Design, 2 Courses in MS Access, and 2 Courses in Programming, so I knew all the basics from courses and personal experience with trial and error. However, for advanced things and correct code syntax I come to...

Ok, I fixed it up for you. There seems to be a problem in Access when you try to remove the focus from a subform to the mainform, there is also a focus maintained on the subform. What I did was make an unbound textbox on the subform named "txtFocus" and set it's width to ".1" so you can't...

Unfortunately I have no other suggestions to solve this problem, sorry. If you have another machine without .NET installed that you can test this Database from, and if it looks bad, then install .NET on that machine and try to create a new access DB, that might help narrow it down.

Install the .NET Framework, and then try to create a new database on that system. And see if the buttons start looking nicer from a freshly created one.

There is an article here explaining how to do this: http://support.microsoft.com/kb/210385 I would just use an input mask of only allowing 3 letters, and then setting the text size to 3, if this suits your needs.

I have the exact same thing and have often wondered, since they are identical versions of Access. I believe I have narrowed it down to having .NET Framework installed. If .NET is installed, it uses the nicer looking buttons, etc. Otherwise it uses the older looking ones.

I believe some of the problems was that you never really implemented the code as it was pasted here. Also, you made a "check" value in the query which created a circular loop which completely broke the subform and queries. I have fixed the database code you requested an reuploaded. I renamed...

Place it right above the code that disables the fields.

Thanks! This is a function I had not used before in the past so was unclear on how it works, it actually creates the dbf file on the other end without it needing to be created. I had looked at exporting this a few times onforums etc. but many things I have come across said it was impossible to...

The code I posted earlier should be put in both On Current and on Click (On click for when changed, and on current for future when surfing the records). I will have to try your shortened version of the code sometime for checkboxes, the code I pasted was originally for using a button.

Hmm, Can you post the database here so we can take a look at it, it seems like it should work. Are there any buttons on this form that you can set the focus to? It sounds weird to make a textbox just so you can set the focus. If you post the database here I can take a look at it tonight or...

Hello, what you are talking about is "Cascading Comboboxes", searching under that name you should be able to find lots of information. Without getting too specific into code, the basic idea is to set the recordset of combobox2 to filter upon the information available in combobox1 using an SQL...

Haha, this is an interesting case of you posting a forum thread, only you reply to yourself and you solve your own problem, it's quite interesting :) Another way to get around this problem, is to use the calendar control in access to set the dates in the text fields, as it will supply the...