Search results

I have noticed that when I add / update (not sure exactly what triggers this) an image to the Access Image Gallery and then put it on a form then upon the next time the form is opened I get I then worked out if I open the form > open the VBE > Debug > Compile, then Compact and Repair twice the...

I am currently adding a lot of images to the gallery for re-use. Unfortunately the images are white and transparent. This means they do not show in the Access Ribbon gallery control unless you put your mouse over it. I have added two images of this. I tried to change Access' color scheme but...

It has been a while for this forum and for MSAccess but I'm back at it updating from Win7 Office 2007 to Win10 Office 2010. I have a few Microsoft Graph Chart object in a form and I am using the onUpdated event of the chart object. That code looks like this; With Me.chart_status.Axes(2)...

Set up is Windows 7 / Office 2007. Access code is automating Word. The following code (which deletes page 2) works on most PCs With objWord.ActiveDocument Set rng = .GoTo(What:=wdGoToPage, name:="2") Set rng = rng.GoTo(What:=wdGoToBookmark, name:="\page") rng.Delete...

Hi all, Access 2007 Front End / SQL Server Backend. I have to change a few column names in my Tables. I am looking for an easy way to check all the places where this column name is used. In VBA modules i can search for its usage, but is there a way to search if the column is used in a form...

Hi all, I seem to be having an issue with the log in with my ipad. When I put in my username and password I get the thank you for logging in but then the login page opens again, empty and I am not logged in. If I go to threads it then shows me as logged in. But if I try to post it then goes...

I have an A2007 file with a lot of helper files such as Office templates, and icons and other files used by Access to do its job e.g.. an ini file for settings and multi language things. Due to my lack of knowledge at the time and because it was easy, in XP my installer program I made myself...

Hi guys, I need to check the language setting of Access 2007. From my reading and what works in A2003, the following should get it. Application.GetOption("Spelling dictionary language")No mater what language I set Access to I get 0. Could anyone make any suggestions please.

I am making a little vb.net program to do some updates that my .mdb currently does when it starts. Currently I update some local tables of the .mdb from SQL server like this; INSERT INTO "localMsAccessTable" ("localColumn1", "localColumn2", ...) SELECT "sqlColumn1", "sqlColumn2", ... FROM...

I have been doing a little bit of reading of the timestamp datatype. I know it is not a time stamp (holding some date / time) :-), as far as I understand when a field of a row is updated so to is this timestamp field. I also know that my Access Front end deals with all this for me. But my...

Hi everyone, I have 2 SQLs which unless I am mistaken are identical. The difference is that from The Access Queries Objects 2003 I have one executing on the table LINKED, the second is a pass through directly to sql server. What I do not understand is why I am getting different results. Could...

I would like to show "YES" if a control is not null or a "-" if it is empty or null. From what I understand of the Format property this should be "Yes";"-"But Access removes the quotes from the second part. So how can I use a "-" in the property? Thanks guys in advance.

I have the following query (I am sorry if it is not formatted correctly) SELECT * FROM tbl_questionnaire AS mt1 WHERE mt1.q_id=(SELECT top 1 mt2.q_id FROM tbl_questionnaire as mt2 WHERE mt1.q_akz=mt2.q_akz ORDER BY...

I receive about 100,000 records from another Database in Access 2003 format. I then read this data into my own database. Given a column how can I query it to find out which record has the most number of characters in it. Something like a MAX(LEN) function.

I realise my query may be complicated but I want to just show the full query. This is copied from a query where I am just testing it. The issue I have is that the field derwent_abstract can have up to maybe 500 to 700 characters. But the result of the below SQL always cuts the size to...

I am currently testng the following - This select works fine. (This is from the query objects of Access) SELECT patent_akz AS q_akz, em.status AS q_status, em.decision_number AS q_decision_number, CVDATE(em.decision_date) AS q_decision_date, em.work_around_ability AS q_work_around_ability...

I am not sure where to start or what to search/Google for here. What I am trying to code (from an Access application) is to be able to allow a user to choose 3 different MDBs which will each contain 1 table. With the three tables I then want to perform an INSERT into a table in the existing...

I have a parent form with a record set (RS1) that results from a users search. As each record can have children they are shown in a subform, but are not always part of the search results and thus the record set (RS1). I have just tested copying (RS1) with Me.RecordSet.Clone to a form level DAO...

Why is this Query not updateable? (Many to Many Relationship) (Edited) Hi guys, I am working with a MSAccess 2003 (mdb) and have a SQL Server 2000 backend. The following query works for me, (which for me is an achievement and I deserve a knock-off beer just for that) but I would like to use...

I am currently designing a form which could have 3 Single Subforms and 1 Continuous Sub Form. (Only the 3 single subforms allow user input - the main form and the continuous do not allow user input) I also have a SQL Server Backend. And the main form which I am getting records from has about...