Search results

Hi all, I am having a problem that is totally confusing me. I have a fairly simple access application that is linked to an sql server. When the user prints a couple of fields print out onto a label whose specifications have been loaded into the printer. I will say that this application...

DannySeager - the truth is I don't know. I've been saying the same thing. But what you're saying is true. THe two fields are exactly alike, the customer just wants it moved futher up above on the form. I could see if they want to keep a history of some sort one would keep the last and the...

It has been quite a while since I've developed a database and I am drawing a blank on how to do this..... I have a form where if the user enters information in one field it will automatically take that information and update (techincally it will replace the data) another field on the same form...

There is probably a real simple way to do this but a couple of us are here racking our brains. :o Is there a way to tell how big a table is size wise? example 1.2mb Thanks, -Sandy :)

I am exporting a table to a text file using a specification. Comma Delimited, no text qualifier. Now, I don't know if this makes a difference but the file is decent size (over 1000 records). The data within each record is exporting fine (about 78 fields) however, I have what is a major...

That's it. There are blank fields in the spreadsheet. I never thought of that. Thank You, that makes sense.

I'm not quite sure what's going on. Right now I'm trying to manually import an excel spreadsheet (File -> Get External Data) to make sure everything is running right before I put it into a macro. Well, if I tell it which table to dump the data into all it does is give me an error message...

After looking at yours, and knowing I did the same thing I looked again and realized what I did was misspelled it. :o Thank you very much; at least I know I wasn't losing my marbles!

I am trying to run an append query where I'm going from a table with no promary key to a table with a primary key. Now the query is doing exactly what I want it to do. However, since there is a primary key in the receiving table, I am getting a pop up box stating that a whole bunch of...

I have created a program that will use a different type of paper other than the paper normally used in the printer. Is there a way to tell my print macro exactly which printer tray to take the paper from? :confused: Thanks in Advance! :)

It works! Thank You very much for your help. I really appreciate it!

I'm not totally sure what you mean by NameOfControl. I tried entering the text box name and I tried entering the form name and neither work. I keep getting a compile error: Method or data member not found. Highlighted in yellow is: Priate Sub Command23_Click() Highlighted in Blue is...

If anyone can help me I'd very much appreciate it. I'm really rust where VB is concerned and my book isn't helping much. I have a form called NonBargainingView. Within the form is a text box called Degree. When a command button is pushed (called Command23) I want Access to look and see if...

I never thought of that! Thank you very much!

I asked this in the reports section but didn't get an answer so I'm hoping someone here will know. Basically what I want to do is when a report is opened in print preview, I want a small form to open also. The form will contain 2 buttons. One will close both the form and the report, and I'm...

Hello all! I have a problem that I hope someone can help me with. This is what I'd like to do. I have a report named SWS. Right now I'm opening the report in print preview mode. I'm also opening a small pop up form called Options that has two buttons, one to Close both the form and the...

I have a form with a dropdown box where the user selects a name. This is the criteria for an append query. Using that criteria the query goes out and searches the main database and appends it into a temporary database. The information in the temporary database is used to select a record and...

I am trying to put together a database for tuition refund. My current database has 2 tables. The first table called Employee contains employee info such as name, location, department, and badge. The badge field is the primary key. The second table called 2001 is linked to the Employee table...

I asked this question before and thanx to charityg, it's working but only partially. I have a form with 9 invisible subforms on it. One of the fields is a combobox named Models (Hence on the main form it is Models1, on the first subform it is Models2, etc). What I want to do is if the field...

Help! I have a form that has 9 subforms on it. Right now the subforms are NOT visible. What I want to do is when a command button is pressed, a combo box will be checked on the form and if there is information in there then the first subform will appear. (Once I can get that working, the...