Search results

Hello, I was wondering if it is possible to pre-processes queries before they are exported. I wanted to do a few things like, conditional formating, column widths and some simple formatting. I currently have a macro to export to an xlsx excel spreadsheet and i dont know if i can code in...

Run-time error "2585" This action can't be carried out while processing a form or report event. I had a macro on a "On Click" Event which worked fine, however I wanted to use this macro elsewhere as well, so I removed it from the "On Click" event and moved it to a seperate Sub and called...

Ah!!! Perfect. (well.. almost :p) instead, in the expression you can use.... [Expression Name]: [Date Field] & "" the only problem is that [Expression Name] <> [Date Field] but other then that... PERFECT!

Hello all, As a perfectionist, I have a problem with the design of my query... The query is there to query data, not to edit data or manipulate data in anyway. However, I am disgusted by the appearance of the date picker when I pick a field that is a date field. I understand some guys can...

Apologies, I was supposed to include some code but I forgot in a rush to get out of the office Code dumps coming up! (I have tried to strip some of them to allow for easier reading, I dont think I have missed any important code in what I have deleted. Combo Box On Update Private Sub...

I have a button to clear all fields and also disables some fields I have a combo box that, on update, fills in all fields and disabled some fields Seperately, they work... but ive noticed a bug. If I get myself into this set up: 1) select an option in the combo box to fill in data. fields...

I used INNER JOIN which appeared to work... it would help if i understood the differences between inner left right and outer join... i get confused between the two

I would like to join my two tables in vba together so I can reference them in the same way, ie. Set rs = dbs.OpenRecordset(SQLstr) Me.Summarystr = Nz(rs![Summary], Null) so I want to be able to combine two tables together in the SQL string in order to have both information inside the...

ive worked out that I can use Me![name of sub form].Form![name of control] in order to get hold of the control... is there anyway I can shorten this so I can write something like... MeSub.[name of control]

I want to display records inside the subform dependant on a unique ID that is selected in the main form. I want to clear the fields, not delete the data or records, just delete the information that is in the current fields, like a "Clear" button to remove the data to give you a blank start so...

I would like to clear the fields, use them to update records in a database when i click a button from my main form, disable/enable the fields. those are the commands im likely to use

can i control the subform from a button in the main form? How would I go about this?

Hello, I am looking for the ability to have a scrollable window inside of a tab. my database is tabbed into categories of data. one of these categories has more than the others I would like to create a rectangle inside the tabbed area which I can put the questions in but the box is too...

Hello, When I have my form up and working on a smaller screen, I can always access the bottom part of my form, in this situation id like to be able to scroll down with the mouse wheel to easily access the bottom half of my form. Can I enable this to work or is it not a form related issue?

Few things... firstly its a 64 machine so the location is: C:\Program Files(x86)\Microsoft Office\Office14\MSACC.OLB Also you will notice Office14, I think Office15 is in Office 2013? were all using 2010. EDIT: This file exists on there machine.

This is the code that fails. Private Sub Progcmb_AfterUpdate() Me.Clientcmb.RowSource = "SELECT DISTINCT [ID].Prog, [ID].Prog" & _ " FROM [ID] WHERE Prog = '" & Me.Progcmb.Value & _ "' ORDER BY Prog" Me.Clientcmb.Value = Null...

Hello, I have wrote a database in access 2010 and the database works fine for me (I am the db admin with full control) I gave the database to a group in which most of them also have no issue with the file. They are able to use the database with no issues One of those members gets an error...

any other answers?

that doesnt prevent sql injection at all though

Hello, I have been looking into a problem I have which appears quite common (the apostrophe problem!) I've seen a common solution is to double up the apostrophe, replacing ' with " to avoid the special character however i also hear of another solution using "parameters". I tried have a...