Search results for query: *

I am having problems not being able to optimise a database for a user having a laptop with a connected larger monitor. When they slide the application from one screen to the other they have problems. I am trying to make a blank form that will have command buttons on to set...

I am trying to modify this SQL for a different database, the function being the same for grouping on Keywords, but wanting different data for the list that it's the rows source. The Query: MySql = "SELECT A.* FROM MAIN A INNER JOIN " _ & "(SELECT M.ID1 FROM MAIN M INNER JOIN KEYWORD...

I have an application made on Windows XP. My command buttons don't use themes and they look good. However the application on Windows 7 looks awful, the buttons are boring grey rectangles. Why should an operating system affect an Access applications looks. Is there a way to get them to look the...

I have a label in my form header, it displays the date and time. I removed the seconds part hoping to kill unwanted flashing of the label as each event happens. I have tried different foreground/background colors but still has an annoying eye distracting flash. Is there a way to cure what...

I am finding it so risky opening up any application I have to modify it or add to it, as I keep getting the message, Sorry, Access has encountered a problem and must be shut down. No helpful suggestion from Microsoft as to what it might be in it's message, just Sorry Any ideas Thanks

I have two related tables Table 1 - MAIN Table 2 - Keyword ID1 Primary Key ID1 Foreign Key etc ID2 Primary Key KeywordName (Text) I have a form with a List Box - Multi Select - List3 The following is not working, I think the output from...

I am having so many problems with Access, using the not in list event. I have tried so many ways of doing it but just kept getting repeated notices of do you want to add etc etc etc and then finally getting the record could not be saved this time, despite it being saved. Then I found some code...

Is there a way to have an Undo button on a main form that will undo the main form and any sub forms? I think if you move off a form to another, the data gets saved, might be wrong? Is there an easy way to get round the problem? Thanks

I get an error trying to find a record based on a date selected from a list box. rs3.FindFirst "ID1 = " & Me.ID1 & " AND NewsDate = '" & Me.List0.Column(1) & "'" I changed it to: rs3.FindFirst "ID1 = " & Me.ID1 & " AND NewsDate = " & Me.List0.Column(1) & "" It does not error anymore, but...

I have a form with a light blue background (solid) Onto which I have a list with a white background, and special effect set as shadowed. I have made the border color black, however there is an unwanted band of another color on the right hand side and the bottom of the list, and I cannot find how...

I keep having an occasional notice coming up saying "The data has been changed. Another user edited the record and saved the changes before you attempted to save your changes Re Edit the record. There is only me on PC. I have a sub form with 3 controls on it. A combo control, List box and...

I have this code to use, however I cannot find the way to get my Yes and No out of it. Seems to goto VBYes all the time? and not VBNo MsgBox "Do you want to associate record with selected Keyword?", _ VbMsgBoxStyle.vbYesNo Or VbMsgBoxStyle.vbQuestion

I am trying to see if a Keyword is in a record set, but getting an error 3070 not a valid field name. I am trying to see if : Set rs2 = db.OpenRecordset("Keyword", dbOpenDynaset) rs2.FindFirst "ID1 = " & Me.ID1 & " AND Keyword = " & Me.Combo3.Text ID1 is a primary key value, Keyword...

My sub form tool in the ribbon when clicked, drops down greyed options, Form, Datasheet, Pivot Table, Pivot Chart. I have tried dragging a form on my sub form, and checking Child/parents links are in, but it does not seem to passed the main forms Primary key. Any ideas, thanks

I have an unbound form with a combo box on. The row source of the combo has a query to a table. However when I click on the combo, I can select an item but when the combo closes it's blank? an someone tell me what I'm doing wrong, thanks

I have a list box, set as simple. Is there a way to know when just one item has been selected in advance of the code below? For Each item In Me.DW.ItemsSelected strlist = Me.DW.Column(1, item) Next item If one item (word) has been selected then I want to offer an edit...

I have posted this before, and did have a template form, however having lost my template I am spending so much wasted time in each property, making font, size, colors etc. Why do we have default fore colors of text you can hardly read instead of black. Is there somewhere in this application...

I am trying to make an ACCDE version open smoothly. I have clicked on the arrow to minimise the ribbon, however when the form opens in what was an MDE type application, I momentarily get the top row of bars showing, ie file etc, and an image of the form is there before it finally opens. It's all...

I have a procedure for selecting records if certain words are in the record. This works okay, producing a distinct list. Now I need to show records that contain one or more words selected from the list, if records do not contain the words selected in the list, then they are not listed. Hope...

I am trying to position and size a popup form, following someone else example which they said worked. I know my settings are inches. I have tried this, but the form is down the screen and away from the left edge. I am using Private Sub Form_Open(Cancel As Integer) Form.Move Left:=0, Top:=0...