Search results

I have a report of a standard form. I use an image of the form as me.picture. The format is as follows: Picture type: linked Picture size mode: stretch Picture alignment: center Picture tiling: no Picture pages: first page I want the fields that I place on the report to line up with the...

I transferred all the tables in a database be from the mdb to a mysql database. When I linked the "fe" to the mysql database most of the fairly simple modules worked perfectly but my main module ran into a "run time error 2448: you can't assign a value to this object" in a bit of code which ran...

I have recently tried to create a MySQL back end to my Access database. In one table, when I look at the key in the MySQL admin, I see that it is type bigint(20) and when I look at it in the design view in Access the same field shows up as type Text size 255. I am not allowed to correct a linked...

I have a database of about 80 tables, each of which has a "GUID" field. I want to delete these fields, but this is not permitted by Access. The alternative seems to be to run a "make table" query on each table leaving out this field. I want to automate this somehow, as the manual version would...

I am trying to save emails to an access database. I advice has been given as follows in the forum (I would suggest that you then get the ID number of this DB record and add this ID to the "mileage" field of the email item. Then you will always be able to find this email in outlook again (unless...

Is there a quick way of deleting relationships on linked tables. I did an "analyze" of a form and it recommended creating relationships for 2 or 3 tables. I took the automated option and it created relationships for all of my tables, some completely inappropriately, and when I try to delete...

I have a mdb with a frontend and a backend. I replicated the be using briefcase and then had to add a few more tables. I now have a be which has replicated and un-replicated tables. When I try to replicate the be, only the previously replicated tables are replicated and not the new tables. What...

I have installed a split database mde as a runtime version on a users network, but I have had a major problem. When I key in new records and try to look at them with a report, nothing appears, although when I look at the input form the records are there. The report should open in preview mode...

I have a split database with a mde front end and mdb backend with all the tables. I added a table to the backend and want to know the best way of distributing the new table. I use the package wizard to create a package to renew the frontend, but I don't want to override what users have done on...

I have a form based on a query with multiple primary keys. I have Company, MemberNumber and DateVisit as the 3 keys. I want to use a combo box to select a member and have been able to do it with the code below, which loops through every record to check whether the selected on exists and then...

I have reports which have jpeg backgrounds, which are standard forms (colored). I want to give the user the option of printing that background form, or , if he/she wants to put standard forms into the printer, print with no background (i.e. blank background). This would economise on ink if the...

I have a problem with adding new records to a combo box. Control source is usually a numeric code (primary key of table) usually not visible (col size 0.0cm) Name is usually visible because it is more user friendly. Adding new record: The user must key in numeric code which is the actual...

Why would the debugger continue stop at a certain part of the VBA after I have taken away the break? Any ideas?

I have a database which fills in a 3 different forms, consisting of 2, 3 or 4 pages respectively. I am using a watermark or background image for the reports produced (i.e. the reports are copies of standard forms). My problems are: a) The reports take too long to load if the images are...

I have a report with a background image (watermark). I have made it a linked image as it makes the report very large. I would like to make the link to the image relative to the current location of the database, rather than an absolute location link. Is this possible? This would enable...

I have looked at the other threads on this but haven't come across exactly the same problem. It is driving me nuts. Here is the code that I am using to select fields in a list box and put them into an unbound textbox: For x = 0 To lstProcName.ListCount - 1 If...

I have a form which covers 2 pages, which I want to reproduce in a report. I can do the first page fine. I scanned the first page and used it as a background (with the problem of field alignment noted in another thread). Does anyone know how to put in the scanned picture of the 2nd page onto the...

I am trying to get a report, based on a query, to open on the current record in the form I am currently in. I have a command control which when clicked issues the following: stDocName = "rptQuinnClaim" sSQL = "[tblQuinn.MemberNumber] = " & Me.MemberNumber & " And [tblQuinn.Date] = " &...

I did a bar graph which had 3 columns, 3 fields, one for each day. It was bit cramped so I edited it by double-clicking on the graph, and deleted a column, and also changed the legend. Now there are 2 columns in the graph and the legend is correct in design mode, but when I run the report, it...

I have a tools stores database and am working on a form to issue tools from one location to another. I have set up combo boxes for: from_location to_location tools_id the tools_id combo box is based on a query which searches a tools_in_stock table for all the tools which are available in...