New to Access, need a little help

Hey guys,

at work, we’re trying to build a database to get an output of all kinds of data from different excel tables (items in stock, sales per week, price, etc) into one table by using the ItemID as primary key for all the tables and as a user input for the queries.

I’m completely new to Access, I do have some experience in Excel and databases in general though. I’ve linked the tables to each other and sucessfully inplemented different queries. However, I have a few questions that I can’t really find a good answer to online:

  1. How can I ask for multiple values when asking for user input? (For example: I want the user to be able to put in multiple itemIDs so they can compare sales/week in a table that has multiple rows)
  2. Is there any way I can automatically link new tables to all the other ones? There’s a new table including data about sales etc. coming out every week. Does that mean I have to manually link it to the other tables in my database and also edit my queries every week?

Thank you guys in advance!
Cheers!

submitted by /u/Brianizer
[link] [comments]

Posted on

Update queries corrupt after latest windows/office update?

Hi all.

Just experienced an issue with our access database. Basically it seems that all ‘update’ queries are showing an error as them being corrupt.

I have done some tests and it only seems to be happening when the database is being run through the latest version off office (which was just updated in the latest windows update).

I think it is V 1910?

Is anyone else experiencing similar issues, or know of a fix other than doing a rollback/system restore?

I hope I have explained myself well enough and this all makes sense.

Many thanks in advance.

submitted by /u/DanJesusWhite
[link] [comments]

Posted on

How can I start report pg. # based on another report’s pg. count?

Hello,

I am trying to start the page number of a report based on the page count of a separate report in Access 2007. I’ve added a text box in report design in my page header section, and I input =Reports!OtherReportName.Pages+1 and it auto-corrects it to =[Reports]![OtherReportName].[Pages]+1, but gives an error when I try to view the report. What am I doing wrong? How do I reference this correctly in Access 2007? All help greatly appreciated!

submitted by /u/Idunnoitsforwork
[link] [comments]

Posted on

I have a drop down list on a form that I cannot get conditional formatting to work on (I want to color the field if text is not equal to certain phrases)

Hello!
I am having a heck of a time. So I have two existing conditional formatting rules for this drop-down field. One makes a field turn yellow if the selected option is either “-” or “” (blank). The second rule turns the background green if the expression is “Complete.” The drop-down list has like 100 more selectable options, and I want a rule that will turn the field red if any are selected other than “-” , “” , or “Complete” but I can’t seem to get it to work by using <>. How can I write this final rule? Thanks!

submitted by /u/MrManager689
[link] [comments]

Get the best Microsoft Access conultant

Get the best Microsoft Access programmer

Posted on

Noob question: search and open record to add data

Hi everybody,

I hope this is the right place to ask this. I am having a bit of trouble with a database I’m trying to create.

A bit of info about the database:
It’s a database for containers. When containers arrive, the check-in is handled by person A. person A creates a new record with a form. The container gets a unique number and some data is added, like what is in it, the time of arrival and what it needs to do here.

When the check-up of the container is done, I need to be able to add the time of departure to the record.

For this, I would like to have a second form where I can let the people search the record on the ID, it opens that record in the same form with the container number, and a field to add the time of departure.

Anybody know how I can do this?

I am pretty new to Access and have learned a lot, but I am really stuck on this problem.

submitted by /u/pika-pika-chu
[link] [comments]

Get the best Microsoft Access conultant

Get the best Microsoft Access programmer

Posted on

How to make For Each loop to cycle through predefined set of controls

So here’s a little problem I’m having in VBA: I have 7 unbound labels on my form to represent dates. I also have a Combo Box with numbers 1-4 to represent a specific week. What I am doing is updating all the date labels to relative to a specific day, and currently updating it manually is a little inefficient:

If Me.weekCombo.Value = 1 Then
Me.d1.Caption = FormatDateTime(DateAdd("d", 1, Me.startDateList.ItemData(0)), vbLongDate)

Me.d2.Caption = FormatDateTime(DateAdd("d", 2, Me.startDateList.ItemData(0)), vbLongDate)

Me.d3.Caption = FormatDateTime(DateAdd("d", 3, Me.startDateList.ItemData(0)), vbLongDate)

Me.d4.Caption = FormatDateTime(DateAdd("d", 4, Me.startDateList.ItemData(0)), vbLongDate)

Me.d5.Caption = FormatDateTime(DateAdd("d", 5, Me.startDateList.ItemData(0)), vbLongDate)

Me.d6.Caption = FormatDateTime(DateAdd("d", 6, Me.startDateList.ItemData(0)), vbLongDate)

Me.d7.Caption = FormatDateTime(DateAdd("d", 7, Me.startDateList.ItemData(0)), vbLongDate)

ElseIf Me.weekCombo.Value = 2 Then

...

So what I want to try and do is make a set of all the date labels (d1-d7) at the top of the function and have a simple ‘for each’ loop that goes through each label in order and updates it accordingly. Pseudo code is below:

if combo = 1 then:

for i =1; i<8; i++ :

d1.caption = DateAdd("d", i, date)

else if ....

Now the only problems I have are A) I don’t know how to make the set of labels, and B) I don’t know how to make the for loop. Any help is appreciated!

submitted by /u/hquaker1
[link] [comments]

Posted on

How to make For Each loop to cycle through predefined set of controls

So here’s a little problem I’m having in VBA: I have 7 unbound labels on my form to represent dates. I also have a Combo Box with numbers 1-4 to represent a specific week. What I am doing is updating all the date labels to relative to a specific day, and currently updating it manually is a little inefficient:

If Me.weekCombo.Value = 1 Then
Me.d1.Caption = FormatDateTime(DateAdd("d", 1, Me.startDateList.ItemData(0)), vbLongDate)

Me.d2.Caption = FormatDateTime(DateAdd("d", 2, Me.startDateList.ItemData(0)), vbLongDate)

Me.d3.Caption = FormatDateTime(DateAdd("d", 3, Me.startDateList.ItemData(0)), vbLongDate)

Me.d4.Caption = FormatDateTime(DateAdd("d", 4, Me.startDateList.ItemData(0)), vbLongDate)

Me.d5.Caption = FormatDateTime(DateAdd("d", 5, Me.startDateList.ItemData(0)), vbLongDate)

Me.d6.Caption = FormatDateTime(DateAdd("d", 6, Me.startDateList.ItemData(0)), vbLongDate)

Me.d7.Caption = FormatDateTime(DateAdd("d", 7, Me.startDateList.ItemData(0)), vbLongDate)

ElseIf Me.weekCombo.Value = 2 Then

...

So what I want to try and do is make a set of all the date labels (d1-d7) at the top of the function and have a simple ‘for each’ loop that goes through each label in order and updates it accordingly. Pseudo code is below:

if combo = 1 then:

for i =1; i<8; i++ :

d1.caption = DateAdd("d", i, date)

else if ....

Now the only problems I have are A) I don’t know how to make the set of labels, and B) I don’t know how to make the for loop. Any help is appreciated!

submitted by /u/hquaker1
[link] [comments]

Posted on

Adding Subreport moves main report grand total

Adding Subreport moves main report grand total

Hello there. My job is in the prehistoric district, where we run Access 2007. I am trying to add a subreport to my main report, which works for the most part. However, I have one issue dealing with the main report grand total in the Report Footer. Before adding the subreport, the grand total in the report footer will show on the last page of the report. However, after adding the subreport to the report footer, the grand total now shows at the beginning of the sub report, instead of the end of the main report.

What do I need to do, in order to add my subreport AND also keep my grand total on the last page of the main report? Any help is greatly appreciated, as I’ve been pulling my hair out trying to solve this for awhile.

Below is the report before adding the subreport, with the grand total working as desired.

https://i.redd.it/49t6xpy4a6431.png

Below is the report after adding the subreport, with the grand total now showing at the top of the subreport page, and erased from the main report on the page before it.

https://i.redd.it/ce1bgfhb96431.png

The amount of space at the bottom of pg.84 is irrelevant. Even with lots of space, the total is shown on the next page.

https://i.redd.it/xc79coc7a6431.png

submitted by /u/Passett
[link] [comments]

Posted on

Modify records via form while using filters.

I have a database where I’m storing customer data which has to be modified rather frequently. In order to find the correct record to modify I pull up the form showing customer data, then try to find the correct customer (about 75 unique records). Using the search at the bottom of the form is one way, but takes time as some customer names are similar. Using filters is great and lets me jump directly to where I want, but the records are locked out and I cannot modify them when a filter is active.

Does anyone know how to bypass this issue?

Edit: I’m using Access 2016.

submitted by /u/ravenssettle
[link] [comments]

Posted on

New to Microsoft – Advice?

Hi all. I am relatively new to access & therefore understand that this may not be possible, I am just unsure. I am looking for alternative programs to use as my ‘Front End’ whilst using Access as my ‘Back End’. Does anybody have any suggestions as to what may be appropriate to use? I am hoping to eventually have a website, is this possible? I had a look at unity but can’t seem to find much information about it.

submitted by /u/laurensummerx
[link] [comments]

Posted on