When a table or query is emailed in txt format, it produces a format that I cannot duplicate using the export wizard or macros. Is there a way to use code...

Is it possible to create a form that will get and update the data from two tables? do some of the fields will be from one table, and other from a different...

Hi I have two combo boxes on a form, cbo1 and cbo2. Cbo1 searches by name and displays total orders in list box (list1). Cbo2 searches by date and displays...

We have a database with 1285 records which need to be amended, never deleted I want to create a button on the form that will delete all fields but one This is...

Hello, I am new at Access and I have a problem that hopefully you can help me with. I have created a simple database with 3 tables: accounts, categories and...

Example: 1. I select 'Homeowner' as one of my options in a list or combo box that I have created for a field named 'Category' (which will contain about 10...

Hi I need a little help with a command for my query. At present I'm using this to find an *exact* match in the whole field I'm searching Like This one...

I created a combo in a form to look up a field (products_model) in a table and then go to that record in the form. When I put it together in my practice...

Hi there I have a database that i created that is used by several different users. Every morning i compact the database and create a copy. this morning i've...

Hello Can anyone help me with this I would like to amend 5 fields on my form with the click of a button. the first field will display EX SYGDC, the next 2...

I am trying to put a command button on a form that will make a pop up window to enter data for the field "product_model" and allow me to go to a specific...

I need a little help please. I have a report which shows all deposits, checks and a ending balance (as a running total) based on a date range (this...

I have a query that has two discriminators. The first one is easy, it just asks if the report is open or not, but the second one asks for the contract...

hi, When I open up a form and it's attached subform, I always get a row of data in the subform. how do I stop that and why is that happening if I don't...

I have a table with numbered rows, How do I add a new record into the middle of the table and get the records to shift down?

To all Normally in datasheet view a new record is added at the bottom of the table. Is there a way to have the new record at the top of the datasheet? Les

How do you change the size of text using 'pcase'?

Hi I would like to count number of columns in some table. I think it should be possible with ADOX (columns object) but if not necessary I do not want...

Alright, I set up a query. Then I set up a form that displays the query information. Then I realized one of the fields was going to need a discriminator in...

dear sir /mam/sister how to calculate total hours worked in hh:mm format of an emloyee between two date or same day in 00:00 hrs format i used function in...