Search results

Hi All My DB has MANY bit fields. Whenever I use the form wizard to create a form, it creates a text box for each field. Is there a preferences setting (or script) that I can use to change all the text boxes (for bit fields) to CHECK boxes. Thanks

Thanks for input. I turns out that I had created a badly structured query. Fixed the query - Now its working as expected.

The problem lies with the manner in which the PDF was created. - You might want to paste the text into notepad / word to "clean it", before putting it into access. In word, use the search and replace tool to remove paragraph (or carriage returns) etc

Thanks Arnelgp I guess that its my own fault for not mentioning that I have tried putting the sub-report in ALL sections. No change in any. I am wondering if I will be forced to have a sub-report for TEST and then a SUB-SUB-Report for criteria. I'd like to avoid this if possible.

Hi all I have created a chart in a subreport The parent report is structured as follows - GROUP - Users info (Grouped by ID_User) - GROUP - TEST info (Grouped by ID_TestNAme) - GROUP - ASSESSMENT info (Grouped by ID_Assessment) - - A bar chart for the ASSESSMENT group is displayed here (and...

I think you may be able to solve your problem in excel, so I will answer accordingly. In Excel, you probably want to create a record number before you do anything to your data. so that you can sort the data back to its original order. Add a column called 'Rec_no'. and then use the autofill to...

OK, so here's how it was set up The back end had tables of its own, but it also referenced tables on a SQL server (connected via 32bit ODBC) The users front end is using 64bit connection to the server. At least that's what I think is happening. I have rolled the access tables into the SQL db and...

Hi Janith If you are using an access generated navigation from, this should be working for you already? However, if you don't like the default colours, check the properties of the tab. You can set the 'Pressed fore color' (Which is the font colour) and 'Pressed color' (which is the background...

Hi all The default navigation form templates are great, but I need a 3rd level of navigation for my project. Is there a way to combine the "Horizontal Tabs 2 level" and "Tabs on the Left" to give me the third level. I tried by creating a "horizontal tabs 2 level" form and then set the target...

Hi Smally Not sure if you managed to resolve the "grey cell" matter yet. This may require a slight change in thinking but.... What about one or a combo of the following. 1. Is there any reason that you cannot drop the Excel spreadsheet and simply create a report ion Access? You can format that...

Yup! I Suspect That It Has Something To Do With Win/office 32/64bit Combinations And Their Odbc Connection. Failing That, Its A Permissions Issue On Ms Access.

Hi All I have created a Split DB that works just dandy on my machine. But when my users try to open the front end, they (very) briefly see the 'enable content' button before being forced to the 'File/New' menu. I have checked that they have set my shared network drive as a trusted location...

Does quickbooks require the user to sign in before they can open a company file?

Hi Paul I think the problem may have something to do with the fact that its parent form is in the Navigation form. So, in effect, what I think is a subform, is in reality a subform of a subform. (ie Navigation Form / Category Form / Activity Form) The two combo's live on the Category form and...

If the button is on the same form as the combo's, you could say if isnull(me.cmbo_SelectFactSheet) then blah else blah blah endif You could also set the buttons 'visible' property to 'no' in the form. On the 'AfterUpdate' event of the combo, you could say if isnull(me.cmbo_SelectFactSheet)...

Why not create an update query to do it without code?

Is a dialogue window open (waiting for input or cancel) under the database?

Unfortunately the attached front-end does not work because there is no back-end (data) attached. And the picture doesn't really help us. I THINK that maybe you need to link a form to the tab?

I have started a new Navigation form (Horizontal with Vertical tabs left - its a template from Access2013) I have two drop down boxes (Category and Activity) When these two have a value, my subform (Frm_ActivitySessions) which references a query (Qry_ActivitySessions) should show all the...

Hi. I have a form that uses ONE of THREE possible combo boxes to find a record. I am finding a record by typing/selecting either the USER_ID (combo1) or SURNAME (combo2) or FIRSTNAME (Combo3) My problem is that I dont know how to update the remaining 2 combo boxes with the relevant info. If...