Search results

Plog very kindly provided a solution to a problem I had with multiple search criteria, but one of the options is causing me a bit of a headache as it doesn't work - and i've only just noticed it! Basically, I'm using a series of If... Then... to concatentate a search string in to a workable...

...but I would like to find a solution to this inconvenience... My database runs on the work's network and the tables are mapped to a back end database. I develop the database at home, so I was hoping to set up a directory structure so any changes I make to the front end will only need me to...

I've got a calculated date in a Query that I'm unable to sort by the result of that calculation. The SQL is: SELECT tblAllApplications.[Initial Planning Application Reference], tblAllApplications.PlanningAuthority, tblAllApplications.[Date of Application] AS [Date], tblAllApplications.Granted...

I have a form for users to enter data and, on clicking a Command Button, adding that record to the dataset. I've added some basic error checking to ensure the necessary fields have data before the record can be added, but I'd like to prevent duplicate records being added. Only the [Reference]...

I have a report that shows a calculated date field (a future expiry date), either 'x' years from a specific date or from a defined date. I'm trying to highlight the calculated date where it is 12 months before today, using the following Conditional Formatting rule: Condition 1: Field Value Is...

I have a database where a form with user-defined search criteria and the clicking of a Command Button opens another form with the results. What I would like to do is not open the form if there are no matching results and use a MsgBox instead. I asked this forum for guidance on writing the...

I have a form with 6 unbound fields on it to enable users to search for records meeting one or any of the criteria they've entered data for. There are a few 'requirements', as identified below: fldA can be used on it's own fldB can be used on it's own fldC can only be used with fldB, if it's...

I didn't want to, but have now decided to make the forms in my database 'moveable', but I was wondering if there's a way of doing this without the form's caption being visible (i.e. when setting the border to 'Thin'). I appreciate I can make use a space " " to hide the form's name, but this...

...and I'm still struggling to do so. Before I trundle further down the path of getting the MoveSize variables from one form and setting the next form to them, here's simple question: I open a search results form from another form, which can have none or many results. Can I limit the number...

So, after a load of work and help from this forum, I've finally got to the test release stage of my database, but something wierd is happening to the formatting of a form when I move the database to my work laptop. Each form was designed on the same template, with the same colours and fonts...

...but I was really trying to do this myself! I have two tables, structurally the same and with a lot of duplicated data - basically, I manually 'fixed' different data in both of them and I'm having difficulty merging them into a 'consolidated table to include both updates. So, in detail: The...

Hello, I would like to open a web-based application from my Access project, but I'm not sure how to 'translate' the javascript to an Event Procedure on a Command Button. The java script is...

I've definitely followed these instructions: Right-click the menu bar at the top of the Navigation Pane, and then click Navigation Options . In the Navigation Options dialog box, select the Show Hidden Objects check box, and then clickOK. ...but I definitely cannot see the hidden items in...

I'm getting this when I try to update fields on a form and, although I've looked on the internet and found results relating to Queries, they don't seem to apply as the form is only linked to a table - and I'm confused (again!) The only thing I can think of that could be causing this is the main...

Hi, I have a Form which I open from two different forms, but which would use the same code on the Click event to set the configuration of that form. As I'm getting fed up changing the Click code on one form and then updating the code on the Click event of the second form, wouldn't it be easier...

...and I'll try and avoid typing errors! Is it possible to open a form and specify the size when it opens, please? The reason I ask is that, when I click a CommandButton to open a continuous form, the number of records varies, but I want the form to stay the same 'height'. Thanks.

...here's a more difficult one - I hope! We use a database application at work which is normally opened in a web page, using a link. I don't know anything about the application itself, but I have (legitimately) been provided with some javascript that will open a specific record within the...

I have a form for users to enter data which is saved to a table, but the dta in one of the fields isn't being copyied over, and I can't see why. tblApplications has these fields: Location - (Data Type = Text, Field Size = 255, Format = @, Required = No, Allow Zero Length = Yes, Indexed = No...

Hi, I have a form (frmZ) that can be opened from one of several forms (frmA, frm B, etc.) When I close frmZ I want to goback to whichever form it was opened from, but (as usual) I'm struggling :o I was thinking of using the CommandButton OnClick event to get the form name, but I don't know...

...as most things are - when you know the answer! I have a form with a ComboBox from which users pick a value. The control source is separate from the form's data table. I want to use a 'viewing' form so users can see everything, but not change it. I would like to change the ComboBox to a...