Search results

I have a continuous form with a text field that says "Select". There are two other fields, one of which is Brand. When the Brand Combo box has nothing in it I want the text box to appear (instructing the user to select a Brand) But once the user selects a Brand and goes to the next records, I...

Cronk - thank you for your advise. I will be working on this next week and will take your suggestion and add the code to the frontend, though I need to transfer a table (already has info in it) rather than create one. Sue

Cronk - Correct it is not added over and over, it is a one time event. Would love to do it manually but can't because yes I cannot go to the site and do this.

Thanks Trevor. Can you give a clue to the difference? More detail: There is an existing frontend that the everyday user works with. This creates reports that are used as sales sheets. Every week there is an update of the database info from an excel file, which I have created a 2nd program...

I have a client that is using a split database. I am working on an update to the program and need to transfer a table to the backend that has the correct structure and information included in it. My thoughts are to make a one time use program that transfers the table to the backend. I have...

Frothingslosh - Thank you again for this module and code - it has solved problems for me in 2 circumstances. My brother who is helping me on my project made the suggestion that you might amend the code in the CompactSelectedDB module so that if the compact and repair fails the user is advised -...

Not sure what you mean by 1:many relationship in the instance.

Solved it by using the following code

That's what I thought - I am sure it is an issue of the display of the folder - not the backup, because I know it worked before. Again - thank you for all of your help!

Found part of the problem - I need to add Trim to the fields - that cleared up the spacing problem. Still need help on the displaying on separate lines and not displaying line if nothing there. Will continue working on this and if I find the solution I will post it for others the future.

I have five reason fields in my table and I would like combine them into one field on my report, with line breaks between so each reason starts on it's on line. Also if there is a blank record, I would like the report not to display a blank line. I have found ways to do this online for 2...

Used yours and it seems to be working. It appears that if you do a 2nd back up the code does not overwrite the first - the date modified on my finder doesn't change. I have not change anything in the backend before redoing the compact code, but even still it should replace the back up file...

Thank you! Through searching I found the same solution as you were posting this. Here's what I have working. This seems to work even though it is slightly different than yours. I will try yours now and go with that since you wrote the original code, this would be a better way to go. Sue

Thank you RainLover. I downloaded your attachment and looked it over, but at this point, the code that was provided by Frothingslosh does exactly what I need it to do except I need to know how to automatically link it to the backend. This must be possible, I just don't have the expertise to do...

I am back using this in another project and would like to use it on the backend of the database. I need it to work only on the backend which is already linked to the frontend rather than hard code the location of the datafile in the programming. Any suggestions on how to make this...

Ended up using a recordset and an update statement. Sue

Thanks - tried to do this as a subquery, which I think I understand you are suggesting, but I get the error "You have written a subquery that can return more than one field without using EXISTS reserved word in the main query's from clause. Revise the SELECT statement of the subquery to request...

I need to find duplicates in one table based on 2 fields, Name and UPC (if there are 2 records with the same Name and same UPC but the GCode is blank) which I have been able to create a select query using the Query Wizard and have made it DISTINCT. I have then set up a query to find matching...

OH - I get it - DUH! forgot the simple step of linking it. Will also test your line of code (missed that when I responded before) so I know for the future. Always appreciate your help! Have a good weekend.

That's the strange part - I tried first adding it to the same database and then added the programming to add it to the backend. Either way the table does not show up in the object list as I described above. It is there but not visible. Sue