Search results

Drawing lines on top of an image in a form might have been fairly easy but as you noted This seems to be true. When I try to assign negative values to any of the properties (Top, Left, Height, Width) I get the error "The control or subform is too large for this location". It seems like there...

I've been able to rotate them with Windows Photo Viewer.

I couldn't see how to download it. You can zip and upload your database here. It appears that I've led you astray and that the place to do this sort of thing would be in a report rather than a form. I don't have time right now to check into the details but if you look at the following links...

I've attached one that someone (arnelgp I think) uploaded a while back. It seems to work ok. They're all going to have code. This one doesn't have too much.

Please be aware that joins don't work in delete queries. At least I could never get one to work. The typical way to delete records in one table that are not in another is to put a subquery in a WHERE xxx Not In or WHERE NOT EXISTS. I suggest checking out the Delete unmatched records section...

I'm not see that but try adding DoCmd.SetWarnings False DoCmd.OpenQuery "MergeData", , acViewPreview DoCmd.SetWarnings True

I don't understand this example but for me to explain in general let's change the code so that we are talking about inches. Me.Line0.Top = Nz(Me.LineTop, 0) * 1440 Me.Line0.Left = Nz(Me.LineLeft, 0) * 1440 Me.Line0.Width = Nz(Me.LineWidth, 0) * 1440 Me.Line0.Height = Nz(Me.LineHeight, 0) *...

You can only add controls such as lines to a form in design view. If you do that your application won't work with runtime, i.e., users would need full Access. If you want your application to be able to work with runtime you can add a bunch of lines to your form and keep them hidden until you...

I suggest taking a look at what's already out there. For example I googled "ms access questionnaire database design" and came across this. If it doesn't do what you want it will give you some ideas about how you might structure your database.

Would you answer JHB's question now? That was

Thanks for the the update on this. DoCmd.TransferText didn't occur to me. It should have as we use Docmd.TransferSpreadsheet to relink some of our spreadsheets.

I looked at it again and noticed that after it deletes the catelog table it starts doing inserts in the CatalogImport table. Maybe this code Dim DeleteEverything As String DoCmd.SetWarnings False DeleteEverything = "DELETE * FROM [Catalog]" DoCmd.RunSQL DeleteEverything should be Dim...

MarkK wrote a class that completely builds an import spec from scratch and executes it. He posted it in this thread. That's good if you are importing something. If the file is just linked I don't think there's a specification at least when you go through the steps to link a text file it...

Also now that I kind of see what this application does I think the information I provided in post 6 is important. In general since the same file name can exist in different folders the file names are not unique. Since the FPath includes both the folder(s) and file name it is unique. Since...

It also deletes the catalog table. I suggest commenting out the lines I mentioned in my previous post and I think you'll find it works a lot more like what you want. At least the comments won't disappear.

The J Street Relinker failed at a point in the code where it was trying to open a database but even before that it was prompting me for a new database location even though the text file (the only linked file) had a good link. I think this was designed with the assumption that it would only be...

The ListFilesToTable procedure which is the first thing called when you click the button deletes everything from the Catalog table with this code found in the ajbFileList module, line 27 Dim DeleteEverything As String DoCmd.SetWarnings False DeleteEverything = "DELETE * FROM [Catalog]"...

Here's some unsolicited information you may find informative :) I noticed that there are duplicate FNames in the Catalog table already. If you run a query to get the distinct FNames like: SELECT DISTINCT Catalog.FName FROM [Catalog]; you get 1818 records out of 2012 records in the table. I...

I got the file ok but I guess I don't understand the problem. The CatalogImport table was empty so I appended the records in the Catalog table to it. When I run the MergeData query either by itself or with the button it doesn't add any records to the Catalog table. It shouldn't as the records...

I believe qryCombinedCounts in the attached database does what you want. It takes a few queries to get there. Considering the count of the unique Unit Names within each Service Name the unique combinations are obtained in qryDistinctUnitsByService which is: SELECT DISTINCT...