Search results

Hi, I'm exporting data from a query to an existing excel spreadsheet. Currently the spreadsheet has 200 rows of data. From the code below, you can see that I am only adding to column A, and adjusting the row height/column width each time, so that the data will fit into the cell properly...

Cool....thanks!

Hello, Is there a way to print the schema of a table right out of Access?? Basically I just want to print out all the field names, data types and descriptions. When looking at the table in design view MS Access 2000 does not give you the option to 'Print'. Any ideas? Thanks Brian

OK, I figured out my code error. Just needed to add a line to check to see if the table is actually linked already or not. Here is the final version: Dim dbs As Database Dim tdf As TableDef Dim strNewDB As String Set dbs = CurrentDb strNewDB = "<path to database>" For Each tdf In...

The exact error is: Runtime error 3219. Invalid Operation.

Well, I figure for development purposes it makes more sense to just use one front end and flip it between the two different back ends. That way I can make any new queries, forms, reports while attached to the 'Sample' backend and not have to worry about corrupting data on the backend with the...

I have a frontend and a backend to my database. Actually, I have two backends....one with real data and one with sample data. Currently when I am switching between databases, I am using the Linked Table Manager, which I am finding to be a bit of a pain. If I am already linked to one of the...

Nope. Nothing is hidden. Everything is pretty much regular. Previously I have never had any problems using Access. This just started happening one day.

MS Access 2000, v9, sp3

Hello, I have a form that I am trying to add a Command Button to using the wizard. When creating the button I choose "Report Operation" and then "Preview Report". The next windows should show me a list of all my reports and let me choose one, but it shows none of my reports....just a windown...

Pat: Thanks! A 'Find Duplicates' on my Union query. Why didn't I think of that. :-) FoFa: Actually, I did use search, but it didn't answer my question.

OK, so I am UNIONing two tables using UNION ALL. It works fine. The resultant table has 192 records (63 + 129). If a use just UNION or UNION DISTINCT I get 184 records. I'm pretty sure that is telling me that 8 records (192 - 184) exist in both tables. How do I query to find out what those...

OK, I figured it out. For the database go to Startup Options and check "Use Access Special Keys". Now it works. Who would have thought of that?!??

Hello, For osme reason this MS Access database I'm working on will not let me debug it. First off, even if I mistype a variable name it is not breaking and giving me an error message. I checked and I do have 'Option Explicit' set as well as "Error Trapping - Break on All Errors" in the Tools...

OK, I have a main form with a field LocID. When a user hits a button I want a query to run that uses the LocID and query a table to see if there are matching records with that LocID. If there are, then open a form showing the matched records. If not, then open the same for as previous, but...

Yeah, that would work and would be a relatively easy solution, but not really a solution to the problem of having one really massive input form. Even though the subforms won't be visible until you hit the button, you still have to design the main form to fit everything in. Ideally, a new form...

I currently have on form with many subforms on it. The main form is linked to the subforms using a field "LocID". Since not all subforms need to be used, what I want to do is to add buttons to pop up a form if the user wants to add data. (This will not make the main form so large and ugly) I...

Ahhh....that helped. I found another post with the same problem. This code worked. Private Sub Check5_Click() If Check5.Value = -1 Then add = "It works" Else add = "" End If End Sub VBA blows!!! Any idea why I don't need to reference...

Hello, So I have a checkbox in a subform that if a user checks then the address info from the main form should be transferred to fields the subform. Here is my code: Private Sub Check5_Click() If Check5.Value = -1 Then add.Text = Me.Parent.add.Text '* city.Text =...

Yeah, that worked....thanks!