Search results

Hi all I have a form with various fields and a number of default values (e.g. 'N/A', '000-000-000', etc) How do I make it where once clicked in the box, those defaults automatically disappear rather than highlighting them and deleting?

Eventually everything will be on Access but for now I'm using Excel to edit the data, (e.g. separate date values and trailing text into their own respective field)

But about for entering new records? Basically, we don't want anymore free text entered dates. Also if there's no date, then at least that cell isn't left empty which i always assumed to be a bad thing with databases in general.

So do you think running reports would be easier with blank date cells? Because basically the criteria for these reports is that 1) the user types in a date range (e.g. 1/2/2012 to 2/3/2016) and all the filtered records within this range appear but also having 1/1/1111 as the default date value...

Hi everyone So awhile back I was splitting up date fields in Excel. In the beginning there was two date fields. The first was called"AAStartDate" and had either blanks or a date entered. The second"AAEndDate" had either a date or the word ongoing entered. I added a third table called...

Thank you. Sorry for being dense but the FE is used by both front end users and also developers? And that is simply the databasename.accdb file, correct?

Okay so If the user wants to use this database to enter new records and at the same time, I can make changes to the database, which copy does each person use?

Hi guys Just need a little bit of clarification. So presently I have this database that I split up and just to be clear, I know that when you split a database, Access adds "_be" meaning back end but is this where developers work or users interact with? Because when I open up _be.accdb all I see...

It's more records. I got it now. Thank you very much.

Is this correct?

On the reports the program codes are separated by a comma. Instead of it being displayed this way (1232, 2212, 3019, etc.). How am I able to display them as as bullet points? 1232 2212 3019

Okay. I youtubed append queries and I think I followed the steps correctly. Here are a couple screenshots of what I've done and here is the SQL: INSERT INTO AgencyProgramCodes ( apc_CodeID, apc_Agency ) SELECT tblProgramCodes.ID, [AgencyINFO-main].ID FROM AgencyProgramCodes, tblProgramCodes...

Hi, first of all, I'm sorry for the late reply. Things are hectic. But thanks for the reply regardless. Now I made a table called what you suggested, made those three fields but my question is how do "link to" table? (e.g. links to tblProgramCodes.ID)? Because right now, it's just an empty table...

Wow, I feel dumb. Thank you sir!

Hi everyone, So before working on access, I had an excel file and did some clean up. A couple phone number fields were entered in a bunch of different ways but I made it where all the numbers are are stored as XXX-XXX-XXXX and put 000-000-0000 in any cells that were empty. When the user goes to...

Hi guys, thanks for your replies. Just to be sure, does Mark's code go on the button's on_click property? Over top of the embedded macro? Thanks

Hi everyone Just out of curiosity, is it possible to program a button to display record count (e.g. 1 of 5)? I know this can be done on the form, but maybe just to save a user an extra step, would this be feasible? I should mention though that this form displays information for different...

Nevermind, I got it working now. Thank you!

Hi everyone So here's my dilemma. I have a datasheet in split form view that displays agency information (agency name, subsidiary, address, city, etc). I have a button for adding new agencies and form opens up with various fields for the user to fill out then hit save. When I look to see the...

Okay so I have a table with these codes stored in them. As seen below, and to store them properly in the query are you saying I need to use this table instead of the main one aka (AgencyINFO)?