Search results

What is the best property to add DSum to a control to? By that I mean, I need to add fields up as theyre being entered. I have this so far: Private Sub Price_BeforeUpdate(Cancel As Integer) Dim Loc As String Dim Calc As String Loc = Me![Wizard step 2 subform order...

I use a query, if the table had for example a column for countries, I would place it under this, and this would search through countries to find it. the complete code would source the code of the search box, e.g. Like "*" & [Forms]![FormName]![SEARCH CONTROL] & "*" This would then use the...

Right so I have been playing around with the goTo New Record function but I cant seem to get it right. I now realise I am aiming for a subform, within a subform (Wizard step 2a is within Wizard step 2b) I keep getting an error telling me "Wizard step 2a isn't open" DoCmd.GoToRecord...

to refer to a subform, this site helpped me: http://www.mvps.org/access/forms/frm0031.htm you would use the .visible = true/false option.. e.g. button_click() SUBFORM.visible = true Not sure how you want it to disappear again but you would simply return .visible = false?

As far as I'm aware, combo boxes will only gues what the rest of the word is... like predictive text. I dont think it will guess the rest of the word. It's useful to a certain extent, like if you pressed C, then H... CHINA would be instantly highlighted... I dont think you could use a combo...

I am having trouble creating a code for a button to add a new item, basically it will save all the data, wipe the form clean but keeping the CustomerID and OrderID the same, and the DescriptionID should go up 1? Any ideas? Private Sub newitem_Click() DoCmd.RunCommand acCmdSaveRecord Dim Loc2...

I got it, lookin at the structure of Sampleless, I noticed what you have done to fix it. I was basing mine on queries, yet what you have corrected is the source code for the form was actually taken from the search bar, relying on the customerID to connect them both. Ingeneous! I can explain...

I thought about what you said and was up all night playing around with your examples you gave me. I think i've figured it out! Thank you so much!! (will update final code when it has been tested)

I figured some things out... thanks for the help. One problem I do have is that mine is Access 07, and instead of a toolbar, there is a bar along the top of the screen where buttons are applied to. By default there is only a save, undo, and redo button. I will look into it further and report...

oh? How do you create menu bars?... that way sounds much cleaner? Then I could use the logo as a background image and everyones happy!

Thankyou so much! I will work through and get back in touch with updates :D

I thought, from a GUI point of view, the main "switchboard" menu would look better instead of a box with buttons in it. I figured I could use an image (the company logo) and have the buttons floating around it. It was a comment made from the end users, who are all graphic designers... I...

i apologise. I didnt think it would be difficult. The wanders of microsoft. I have placed it on my site to download: http://www.chrisopia.co.uk/example%20DB.zip I have had to import some sample data because my list of 1300 had some pirvate data on. hope this helps?

I created a search tool and it would error whenever there was an apostrophe in their name... either company, first or last or even address. I figured it was because of this part of the code: Me.RecordsetClone.FindFirst " CompanyName = '" & Me.SearchBox & "'" Where if there was an apostrophe...

Im not ignoring you, but I just wanted to try something, and found that the query listbox I'm using, "SearchBox" has an option "BoundColumn" I then found out that it was set to "2", which is the column in the query where the Company Name is kept. I experimented, and 3 was first name and 4 was...

Ah, I did something and I now keep getting error 3464: which is a data type error. Perhaps thats why i initially thought it was a autonumber problem, as everything else is text? Any solutions?

Private Sub SearchBox_AfterUpdate() Me.RecordsetClone.FindFirst " [CustomerID] = ' " & Me.SearchBox.Column(0) & "'" If Not Me.RecordsetClone.NoMatch Then Me.Bookmark = Me.RecordsetClone.Bookmark Else MsgBox "Could not locate [" & Me![SearchBox] & "]" End If End Sub Run-time error...

Ah, I see. I would consider using DMax, but was unsure how to work it, and I have tried really hard to figure it out. It seemed to retreive the highest value, but then the numbers weren't being saved, and it just kept updated them all: BUI001 or BUI002 BUI002 or BUI003 BUI003 BUI003n which...

the NameID, counting upwards uniquely the example there showed: BUI001 SMI001 BUI002 SMI002 and so on...

Hi there, I am not very good at the count query and have tried many tutorial websites and forums to figure this out. I have a list of company names, and a list of last names, I have created a query that filters through, taking the first 3 letters of the company name, and if it doesnt exsist it...