Search results

hello ridders, you say to use a professional installer package, any particular one?

question, how many of you have sold a database you have made? and if so how do you go about doing it?

hi all can you help please, i have a form on which is a number of tick boxes relating to columns that are on an excel sheet that is produced when i click a button on the form , how do i get the sheet to be produced so if tick box1 is true then tthe column that is assosiated to is either hidden...

hi minty, i have opened the query and cannot enter any new records

hi all can you help please , I have a form that works ok but when i want to add a new record i click on the new record icon on the bottom of the form and it then opens up a new blank record BUT i cannot write in the texboxes or copy and past into them, any ideas please :confused:

hi all can you help please. i have imported an excel worksheet into a database and when i use the table analyzer wizard on it i get to the end and it comes up with "file sharing lock count exceeded. increase maxlocksPerfile regestry entry" i have looked online for the solution but none seam to...

or would this be better achieved through VBA ? if so can you show me how please.

hello all, can you help please, I have a query [runquery] and I has a column called [result] the column either contains the value "acc" or "rej" , what I need is find out the percentage of rej against acc , and the total of acc and rej . can you show me how please.:o

i hope this helps

hello sneuberg, what I am trying to achieve is this , I want to export the contents of a query to excel under a set name and format the spreadsheet to a set format , I know I can export via a macro but this wont let me format the spreadsheet ,i have found out how to TransferSpreadsheet to a...

Minty , thank you for your reply, but this did not solve the issue , hello sneuberg , thank you for your reply also , but this is beyond my skills and don't know how to implement this to try it .

hello all, can you help please, I have the following code to try and make a recordset, when it gets to [Set rs1 = CurrentDb.OpenRecordset(SQL, dbOpenSnapshot)] it keeps throwing up an error "runtime error 3061 to few parameters, expected 1" what am I doing wrong and how do I rectify this...

can you help please, I am trying to save an excel workbook under the name of the value in a text box called [drawing] on my form Dim rep As String Dim theFilePath As String rep = Forms![Mainform]![Drawing] theFilePath = "C:\Users\owner\Desktop\export to excel\rep .XLSx"...

hello all, can you help with my problem please, I have a form with subform that I wish to save as an excel spreadsheet, I can save the subform via a macro , but what I am trying tp archive is this . 1. on the form [mainform]I have several text boxes [client name], [drawing name] and [project...

thank you apr pillai for your help , but I am running access 2016 and on this expression builder does not show a paste option

hi arnelgp, just one issue with this , if I use this on a column this is in between two other columns then it leaves a space on the report, how do I get the visble columns on the right of the one I have just shrunk to move right ?

hello all can you help please , can you use "columnhidden on a report" I can get this to work on forms but not reports , if you can use it on a report what would be the correct syntax please , if not how do I hide columns on a report based on tickbox's for each column that are on a form...

thanks ranman256 , but what do you mean by the picker?

hi all , can you help please, I have a report [mainrpt] and a form [mainform] the report loads the info from a subform , what I am trying to do is on load look at the mainfom and see if a tickbox is true or false , and then place the answer in a columnhidden to hide or show it, ive tried this...

update , they work on table but not on subform