Search results for query: *

I have a system (fe and be) on a shared drive. It works fine for 2 out of 3 people. the third person, when they try to make a change (bound form), will get a message that the form can't be found. If it was everyone, I would say it is how it was named in code but it's only one person. I...

Andy and Duane, Adding the quotes to Andy's suggestion did the trick. Thanks

Hi Andy, at the table level I have Format: Short Date Input Mask: 99/99/00;0;_ Required: No I had removed the input mask and tried it but still wasn't able to save. How do you mark a datetime as being able to accept a null? When I make your change, it still gives me an syntax error. The...

I am using access 2010I have a sql statement to insert information into a table. If I have dates in date fields, it works fine. If I don't fill one it, I get errors. I've read the posts and tried what was suggested but still no success. Can someone see what I'm doing wrong? My default...

Duane, I created a user manual that I would like to have on a tab on the menu bar. Right now the menu bar has File, Home, create, external data ... I'd like to add "User Manual" and when they click that tab, have the ability to open the word document. I looked at the Quick Access Toolbar...

How can you add a key User Manual (word document ) to an access 2016 database Thanks lhuffst

sorry it's been so long responding - I'm yanked from project to project it seems. I was hoping to use as much original code as possible from the original coder. Based on your forms I'm restructuring this one to be normalized. Thanks for the help

DHookom My apologies. I thought that for so few lines it wouldn't be hard to read. I'll correct that in the future. Yes I have done combo boxes and can use the wizard but this is slightly different so I wasn't sure. TblFees Fields: fld2wk3inSvcChrg fld6mo3inSvcChrg fld2wk75inSvcChrg...

If I have a table that has these fields: SrvChrgSize SrvChrgAmt fld3-2wk 30.00 fld3-6mo 120.00 fld75-2wk 60.00 fld75-6mo 140.00 How would I do the combo box that lets them select the field and corresponding charge? Currently I have 4 columns horizontal but that's...

my mistake. Thank you guys

Hi. Our company is deploying office 2016 to take advantage of office 365. My question/concern is that I have not finished changing all the access databases to the newer versions. Will databases that are version 2003 but running under 2010 still work when 2016 is deployed. Since this is a...

I moved the formula to the form on current I changed the text box decimal places: 0 format : 0000 This looks now Thanks

dHookom. That's what I tried originally Total Gals: 132580 puts thousands as 132.58 I only want the 132

I have an odd request from the customer. One of the fields is total gallons which can be hundreds, thousands or more This is not a problem. Now they want to add another field that shows only the thousands of gallons based on the first field. How do I do that? for example Total Gal: 181700...

MajP Thank you very much for all the help. Still struggling somewhat but your explanation was great! Definitely helped me...

Hi Majp Sorry it took so long to get back I have been making the changes you suggested and it seems to be working in some places but not others. I am in the process of moving old databases to newer versions and wanted to try the navigation options which started me down this path. I am still...

I have a navigation form that I want to requery the recordset of a subform when returning from a different form. I'm having a difficult time getting the syntax correctly and need something to help. Mainform with navigation buttons: ShopOpNavigation Errors button on Mainform: Opens...

Finally (after days) of trying different things, I got it to work. changed the following. On Report 1 txtStart Control Source is now =[Forms]![ShopOpNavigation]![NavigationSubform].[Form]![txtfromdate] txtEnd control source is now...

redid the reports for the umpteenth time :) Form frmReports, you fill in txtfromdate and txttodate. Report1 Added 2 text boxes TxtStart control source =[Forms]![frmReports]![txtfromdate] txtEnd control source =[Forms]![frmReports]![txtToDate] Recordsource is now: SELECT...

I need help on how to correctly identify dates from a form in queries. I have MainForm: ShopOpNavigation (used the wizard) Subform: frmReports where the user enters txtFromDate and txtToDate That is fine. Reports: Main Report: Report1 which has only titles for the report, no...